Producing report

[Guest]

A bit of a wide ranging question, so sorry if i ramble.

I'm producing a number of reports from a pool of data, but each report can
be based on one of 3 aspects of the pool. What i would like to know is what
would be the best way of going around this? Bearing in mind i would like to
keep this simple,as the end users have little or no access database knowledge
and that i would like to them to be able to add more reports.

 

[Arvin Meyer [MVP]]

Use a query for the report and use a list box or combo box on a form to
select your criteria. Once selected a button on that form will open the
report.

The query ceiteria should look something like:

Like Forms!TheFormName!ListBoxName & "*"

This will match the value in the listbox or include all values in that
column if nothing is selected.