Help in creating report from Query

[pkondilys]

This is probably a simple questions, but any help would be great:
I have a report that I would like to create of a query that I am running. The query when run will give you the results of a specific record in a table. How can I get the resulting info onto a report?

Thanks

 

[randysmid]

Hi,
You can use the Report Wizard to create a report based on your query as the recordsource. And, to add more functionality, I wrote 2 FAQ's on how to use a form to specify criteria (such as a specific record), that determines what will print on the report:
1st one uses filter: faq703-2657 (no query used)
2nd one uses query: faq703-2696

The nice thing about these techniques is that you can use multiple criteria, such as customers in California AND Nevada, but only those who have YTD purchases greater than a specific amount.

HTH,
Randy Smith
California Teachers Association