Modifying text boxes in a report?

  • Thread starter Thread starter srbanksphd
  • Start date Start date
S

srbanksphd

Hello,

I'm editing a report that was created by someone else. The report has about
100 different text boxes. An example of the code in a text box is:

=DCount("[ms_id]","Patient_Status","[gender]=1 and [site]=1 and [refuse]=2")

So there are a bunch of columns (i.e. when site = 2, 3, 4, or 5) and 16 rows
(when gender = 2, or refuse = 1, age = <65, etc.)

I need to add another variable ( [year]=2008 ) to all of these text boxes.
Then create another report for 2007 and 2006.

How can I do this without going into each text box and changing the criteria
individually?

Thank you in advance.
 
Is the report based on a query?

If so, why not turn the query into a perameter query by entering:

[Enter the year you wish to report] in the criteira row of the year column?

The user will be asked to enter the year on opening the report. The query
will only be populated with records for that year.

Sorry if I have mis understood the situation with your report if this is not
the case??

Regards
 
Back
Top