lewando_bria
BoRiS
- Local time
- Today, 10:35
- Joined
- Jun 18, 2002
- Messages
- 29
Hi, I need to add a section in a page footer for a report that tallies up values from a field in the query that the report is based on...I will try and describe it as best I can....
The query has a field that looks like this
Hours Weight: IIf([Actual Hours]<41,"Low",IIf([Actual Hours]<240,"Medium","High"))
this gives the field a name of "Hours Weight" and Marks each field for a record as either "Low", "Med", or "High" depending on the number of hours contained in the field [Actual Hours]
In the report I would like to have the total number of each type ("Low", "Med", and "High") displayed in the page footer...
i am not sure how to access the information contained in the query through VBA so that I can obtain a number for each category...Any help would be greatly appreciated...
The query has a field that looks like this
Hours Weight: IIf([Actual Hours]<41,"Low",IIf([Actual Hours]<240,"Medium","High"))
this gives the field a name of "Hours Weight" and Marks each field for a record as either "Low", "Med", or "High" depending on the number of hours contained in the field [Actual Hours]
In the report I would like to have the total number of each type ("Low", "Med", and "High") displayed in the page footer...
i am not sure how to access the information contained in the query through VBA so that I can obtain a number for each category...Any help would be greatly appreciated...