Replacing Field names in a Report

[Palmer]

Hi,
I have a report (report A) driven by a query (Query A). I want to copy the report because of the formatting. So now I have report b that needs to be driven by Query B. Is there a way to change all of the fieldnames in the report using a find and replace?

Ex.
querya.field1 needs to be changed to queryb.field1


Thanks in advance for any help,

Matt

 

[ddmcn]

Nope!

I don't think so. When you change the record/control source of the new report to Query B it will not know what to do with all the fields in the report...it will be looking at QueryB and looking for information that is identified as QueryA...

You'll probably just need to delete the old fields and place the new ones on the report.

Sorry.

Dennis