From: Karen on
I need to copy a report to create a second report, and am looking to know how
to globally change formulas to a different table/query. The fields in the
two tables are identical, the data results are different.

Example of a Current formula:
=Sum(IIf([Customer Sat Results database]![The service or information you
received was appropriate and help]="Good",1,0))


New report formula would be:
=Sum(IIf([Internet Customer Sat Results database Query1]![The service or
information you received was appropriate and help]="Good",1,0))

there are about 96 formulas that need the table/query reference changed...

From: Jeff Boyce on
Karen

This may seem a bit off-topic, but let me start out asking about the
underlying tables ...

If, as I infer from your description, you have two tables with identical
fields, I have to ask "why?" It would be quite rare in a well-normalized
relational database to need "duplicate" tables.

If you'll describe what business need you are attempting to satisfy by using
two (?or more?!) identical tables, folks here may be able to offer alternate
suggestions that both take advantage of Access' strengths AND get your
original request satisfied.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Karen" <Karen(a)discussions.microsoft.com> wrote in message
news:876DDA67-D8B6-4298-876F-79FFD76E395C(a)microsoft.com...
>I need to copy a report to create a second report, and am looking to know
>how
> to globally change formulas to a different table/query. The fields in the
> two tables are identical, the data results are different.
>
> Example of a Current formula:
> =Sum(IIf([Customer Sat Results database]![The service or information you
> received was appropriate and help]="Good",1,0))
>
>
> New report formula would be:
> =Sum(IIf([Internet Customer Sat Results database Query1]![The service or
> information you received was appropriate and help]="Good",1,0))
>
> there are about 96 formulas that need the table/query reference changed...
>


From: Duane Hookom on
I agree with Jeff's assessment but would also wonder why you even need to
have the table name in an expression in a control source of a text box. Table
names included in expressions would only be required if there are two or more
fields in the record source that are exactly the same.

--
Duane Hookom
Microsoft Access MVP


"Karen" wrote:

> I need to copy a report to create a second report, and am looking to know how
> to globally change formulas to a different table/query. The fields in the
> two tables are identical, the data results are different.
>
> Example of a Current formula:
> =Sum(IIf([Customer Sat Results database]![The service or information you
> received was appropriate and help]="Good",1,0))
>
>
> New report formula would be:
> =Sum(IIf([Internet Customer Sat Results database Query1]![The service or
> information you received was appropriate and help]="Good",1,0))
>
> there are about 96 formulas that need the table/query reference changed...
>