Counting Query

[ranjah]

I have two reports i run every so often in those reports i have a criteria set which asks me to type yearly, lifetime or three year and then after report prints out it also has total member quantity query on top of the page which counts whatever membertype i am typing it in, however right now its only counting yearly members.

I was wondering is there an easy way to just count the yearly members, lifetime and three year separetly on top of my reports?

Member types total count is....

yearly 400
three year 25
lifetime 70

 

[ranjah]

Anyone out there wants to take a shot at it??

THanks

 

[Fear Naught]

You need unbound text boxes that use either the DCOUNT() function or build yourself a function to do it.