Alter Query.

[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

 

[Rick Brandt]

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.

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.

 

[Alam]

Hi Rick,

I would like to alter the query (SQL) that I am using at the report.

Tausif.