Queries and reports - how?

  • Thread starter Thread starter rleblanc
  • Start date Start date
R

rleblanc

I have a query that finds the exact data that I need for a report. It
presents it in table form which is fine.
Then I need to run a report against the data acquired by the query. How do I
tell the report to use the data in the query result and not the data in the
raw tables in the data base.

PS: Basically the query finds only data between two dates. The report then
uses that data to provide a report of monthly, quarterly, and yearly
activities.

Thanks!
 
Hi
Use the report wizard,
the drop down box for "Tables/Queries" select you query.
It is then placed in the record source for the report
HTH
Marc
 
If I understand you, you want to take an existing report and substitute an
alternate set of data (or make a permanent change). If that is so:

1) Make a copy of the report (Open it in design view and "SaveAs")
2) With your new copy in design view, change the Recordsource property of
the report to the name of your query
3) Run the report

For this to work cleanly & without any further design changes to the report
(which is the reason you made a copy), all the FieldNames from the original
recordsource that were actually used in the report must be present in the
query.

Once you have this working to your satisfaction you can delete the original
report if this is a permanent change.

HTH,
 
Back
Top