Getting Data From Query (1 Viewer)

[lewando_bria]

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...

 

[Rich]

=Sum(IIf([Actual Hours]<41,1.0) etc,etc as text box control sources,no vba is required