If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copy format and formulas of one report to a second report
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... |
#2
|
|||
|
|||
copy format and formulas of one report to a second report
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" wrote in message ... 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... |
#3
|
|||
|
|||
copy format and formulas of one report to a second report
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... |
Thread Tools | |
Display Modes | |
|
|