Whats the Best Way to do this ?

[Craftsman61]

What I am looking to do is to have the user select one of five different criterias as basis for one report. In other words no matter which criteria the user selects (they can only select one criteria) the report design / output would be the same for all 5 criteria's except of course the criteria being used.

criteria 1
criteria 2
criteria 3 the report.
criteria 4
criteria 5

What this is is five different error type codes, the user selects one type and the report would show all five criterias and other needed information.

Should I use a select case statement, a complicated query criteria design - what would the best route be to accomplish this.

 

[randysmid]

Hi,
I wrote two different FAQ's on how to pass criteria to a report, either via a query or with "filter". Here are the FAQ's:
form and query: faq703-2696
filter: faq703-2657

Please let us know if you need any additional information. HTH,
Randy Smith
California Teachers Association