Build Report Based on Form Input

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

Guest

I want to make a report based on the users input on a form. I would like them
to be able to design there report by either choosing a location from a list,
or by entering a beginning date and an ending date. What is the best way to
accomplish this?
 
javageek said:
I want to make a report based on the users input on a form. I would
like them to be able to design there report by either choosing a
location from a list, or by entering a beginning date and an ending
date. What is the best way to accomplish this?
Click to expand...

If it is an "or" situation then you can build two reports and base each on a
query.

In the criteria for the location report place
Forms!YourFormName!YourLocationName.
(This assumes only one location per report.)

The other report would contain "Between #Forms!YourFormName!StartDate# AND
Forms!YourFormName!EndDate

For this type report I usually use a location table with a Boolean
"PrintThis" field.

I have buttons to clear all and select all PrintThis fields.

A subform is used and the user selects the locations by checking them and
fills in the dates.

The query is based on PrintThis = True and the date selection above.

Report design determines if the locations are grouped or each location gets
a separate page.
 
Back
Top