how do i change query on which a report is based

[Guest]

I have a report based on a query and want to use it to report results from a
different query which has identical fields. How do I tell the report to look
at the results from the other query?

Thanks

 

[Nikos Yannacopoulos]

If this is a one time change, then open the report in design view and
display the propeties window; select tab Data, and change the setting of
the Record Source property to the other query.

If this is something you will need to do all the time, then you can do
it programatically at runtime.

HTH,
Nikos

 

[Guest]

Nikos

Thanks for your help

 

[Guest]

And how do you change it programatically at runtime?

 

[Guest]

I built a table, then 5 queries from that table. Each query has the same
fields – but I wanted them sorted them differently, that is why I built 5
different queries. Now I’m trying to build 5 different reports, each one
based on one of each of the queries. Got the report built - all pretty and
everything!. Seemed to be working fine. Then more records were added. The
query still works – but when I go to run the report, it puts all the newly
added records first, and then the ones that were in the table when the report
was built show up. So it is not re-sorting the records.

 

[Guest]

Does this work if you are generating a report directly from a query or do you
have to do it from a table? When I open the DATA tab there are no choice
available.

 

[Duane Hookom]

If you have any tables or select queries in your MDB then you should see
these in the Record Source property of your report. If you don't see the
Record Source property, you are probably not viewing the Report properties.