I have made a table of defects using headings such as System/Subject, Details, Action, Status, Notes, etc.
I have created a form to add defects and search through the list of defects.
The search form contains two text boxes for searching with two keywords i.e first search can be "CCTV" so it brings all records with CCTV then second keyword might be "blank" so it might show all CCTV issues with blank in their description etc.
What I want to do is run a search through my search form and based on the results of that search I would like to produce a report that can do one or all of the following;
Optional extras for visual purposes mainly. Is it possible to;
Create a report template so all new reports conform to this format.
Im new to access so if something is obvious and I have not picked up, pardon me
I have created a form to add defects and search through the list of defects.
The search form contains two text boxes for searching with two keywords i.e first search can be "CCTV" so it brings all records with CCTV then second keyword might be "blank" so it might show all CCTV issues with blank in their description etc.
What I want to do is run a search through my search form and based on the results of that search I would like to produce a report that can do one or all of the following;
- Produce a new report
- Print the report
- Email the report
Optional extras for visual purposes mainly. Is it possible to;
Create a report template so all new reports conform to this format.
Im new to access so if something is obvious and I have not picked up, pardon me