how do i change query on which a report is based

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: ARD <ARD@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 28 Jul 2005 03:53:01 -0700

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
.

Follow-Ups:
- Re: how do i change query on which a report is based
  - From: Nikos Yannacopoulos

Prev by Date: Re: How can I change text direction in access?
Next by Date: Re: Create report in MS-ACCESS
Previous by thread: Re: How can I change text direction in access?
Next by thread: Re: how do i change query on which a report is based
Index(es):
- Date
- Thread

Relevant Pages

Re: Populating a list -- table structure?
... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
(microsoft.public.access.forms)
Re: Fields in Label dont give correct information
... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
(microsoft.public.access.reports)
Re: Tips on domain aggregate replacements
... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
(microsoft.public.access.modulesdaovba)
Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms)
Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms)