Programing reports to print?

[Guest]

Currently I have 8 identical reports that print out information according to
the 8 idential queries that filter on one row in a single table; "I hope that
makes sense."

I need to change this so I only have 1 report and 1 query. In doing so I
need to have the query look at a table that has the row of information to
filter on then have it print the report for the appropriate filter. I would
also like for the report to be named according to the name the query filters
on because I export these reports to a XML format.

Can anyone tell me how I can accomplish this?

Thank you in advance,
Tony

 

[Guest]

Tony, why can't you just use a null or not null stmt in the criteria row of
the single query that determines what to print? You would have 8 rows of
criteria in your query to test all 8 possibilities. Let me know if this
helps.

Destin Richter
(e-mail address removed)

 

[PC Datasheet]

Look at QueryDef in the Help file. You can create a querydef at runtime and
use the query then for your report.