Generate Different Reports from a sinqle query - Pls Hlp!

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

Guest

Please help! I have a parameter query with many fields and 3 different date fields. (the parameter is off the type of committee) A report is generated from this query. However, I was to to generate a report if need for each different date field. I thought the easiest way to do this would be to make a parameter query for each date field and a different report for each query. (this means I would have 3 parameter queries for each date field and 3 reports) I would like to eliminate this and instead just have one report and one query and be able to generate a report from this query for any of the date fields required. Is this possible? Can this be done without Code? I am not proficient in code.

I tried applying the criteria via the Where Condition but that did not work. It works for the first report, but not the second.

Thanks very much in advance for any help I can get.
 
One approach would be to build a form on which you "collect" the various
settings, then add a <Print Report> command button that uses the form's
fields/contents to dynamically build an SQL statement and opens a report
using that SQL.
 
Back
Top