Changing the Field List

[SP76]

Hi,

I have copied a query and renamed it as I want a report to be selected by a specific criteria which is ready and working.

I have copied a report and renamed it now what I want to do is to change the "field list" to display the new query so as the new report will pick up the criteria I have created in the new query.

Or is there an easy way to update the new report with the new query?

Anyone help?

 

[Kiwiman]

In the design view of your report, Top left corner, right click and show properties. Go to the data tab. Change the recordsource to your new query.

Depending on the Column headings of your new query, you may have to change some of the record source of the individual controls on your report.

 

[mister]

Where in the report do you click to get this? When I go to Properties to change the Data Source, I don't see an option for Record Source.

 

[SP76]

This has worked for me. Thanks Kiwiman