Form -> Query -> Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I go about setting up a Form which would allow a user to select the
following criteria and then use this to pluck info from a table and place it
in a report.

The criteria would allow the user to select one of the following
- Show all records for all machines for the last 24 Hours / last 72 Hours /
7 Days / 14 Days
- Show all Records for a particuler machine selectable from a list for the
same time frames
- Particular Start and Finish dates for either one or All machines.

Any help is much appreciated
 
Hi Richard

the basic steps to achieving this are:
1. create the query that the report is to be based on
2. use the report wizard to build a report based on the query
3. create the "report options" form - ensuring that i name each control
something easy to find later (ie if its the start date that i want i name
the control startdate) - close & save form
4. return to the query, click in the criteria line of the field that i
need to reference the control on the form
5. click on the expression builder icon on the toolbar
6. go to forms / all forms / find my "report options" form, in the centre
section double click on the form control that i am using as the criteria
do this for all of the criteria that i'm setting
7. close & save query
8. return to the form & put a command button on it to open the report in
print preview mode - close & save form
9. open form, set criteria, click print button

hope this helps
Cheers
JulieD
 
Back
Top