Alter Query.

  • Thread starter Thread starter Alam
  • Start date Start date
A

Alam

Dear All Guru,

I have an old report. I would like to change its query. How can I alter the
query for that particular report. Thankx for the help in advacne.

Tausif
 
Alam said:
Dear All Guru,

I have an old report. I would like to change its query. How can I alter the
query for that particular report. Thankx for the help in advacne.
Click to expand...

This is a bit of an ambiguous request. Do you want the report to use a
*different* query or do you want to alter the query that it is already using?

In other words, if you look at the RecordSource of the report in design view you
will (likely) see the name of the query it is currently using "SomeQueryName".
You can just change that RecordSource setting to the name of a different query
(assuming it has all the same field names) or you can open "SomeQueryName" from
the db window and make changes to the design of that query. The latter assumes
that "SomeQueryName" is not also being used in other places where a design
change would cause errors.
 
Back
Top