find and replace in reports

  • Thread starter Thread starter Tom Brown
  • Start date Start date
T

Tom Brown

I have a couple of hundred DSum functions pulling detail information in my
report.
Here is an example of one of them:

=nz(DSum("Amount","tbl_NUS1TaxYr2006","TaxType=""" & "accr" & """ and
PLPCTR=""" & "P220703" & """ "),0)

Since I created a new table, tbl_NUS1, I want all these functions in the
report to now point to that table.
Is there any way to do a find-replace operation so that all the
"tbl_NUS1TaxYr2006" can be changed
to "tbl_NUS1" at the same time? Otherwise, do I have to go into each
function and change them by hand?

Thanks for your help.

Tom
 
Hi Tom,

If this is only for a few queries here is a suggestion that worked for
me. View the query in SQL view, copy the SQL to notepad and use the
replace function (CTRL H) to find "tbl_NUS1TaxYr2006" and replace all
with " tbl_NUS1". Then copy and paste back over the existing query and
save. Worked like a charm for me and saved a lot of re-write time. .
There may be a search and replace in all queries function that I am
unaware of.

Hope this helps
VIC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSum multiple types of criteria 2
Pull year from mm/dd/yyyy field into report 4
Reports, Sub-reports running sum and no data 2
Dsum in report header problem 6
Erratic Report Field Format 6
Find and Replace in Access 2007 1
Accumulative SUM for records in a Report (Leo Asked) 4
Dlook & DSum in Report and groups by Report Groupings 1

Back
Top