Hi All
I've got a report that I run monthly and will need to add a month and delete the previous month. The formulas will need to be altered to add the new month. There are probably 30 formulas that will need to be altered. I wondering if anyone has encounted a way to find and replace in the design view of a report? I don't want to change the data in the database just the formulas. For example:
This formula will need to be
=IIf([PK Contract Type Description]="Pending",[AccessTotalsJan 15]*0.75,IIf([PK Contract Type Description]="Prospect",[AccessTotalsJan 15]*0.25,IIf([PK Contract Type Description]="Proposal",[AccessTotalsJan 15]*0.67,[AccessTotalsJan 15])))
This formula
=IIf([PK Contract Type Description]="Pending",[AccessTotalsFeb 15]*0.75,IIf([PK Contract Type Description]="Prospect",[AccessTotalsFeb 15]*0.25,IIf([PK Contract Type Description]="Proposal",[AccessTotalsFeb 15]*0.67,[AccessTotalsFeb 15])))
Doing this manually on a monthly basis will be time consuming. Any way that I can do a find and replace in the formulas (find Jan replace with Feb)?
Thanks in advance.
Tammy