Display a count of "Type"

[CoffeeGuru]

I have a report where I have added a package type to my Query (STD or XL)
I have currently included this in the report although I dont need to show it, however I do need to show at the bottom of my report how many rows are Type "STD" and How many are Type "XL"

 

[pr2-eugin]

You could use something like..

=Sum(IIf(Type="STD",1,0))
=Sum(IIf(Type="XL",1,0))

In two different Text Boxes in the Footer..

 

[CoffeeGuru]

Hmmm I'm getting #Error
slight change to your example "[]"
=Sum(IIf([Type]="STD",1,0))

 

[pr2-eugin]

Yea.. Might have thought about that, Type is a Reserved word in access.. Maybe a good time to check !

 

[CoffeeGuru]

OK Ive changed the field name to [Package Type]
but still getting #Error