MySQL Forums
Forum List  »  Microsoft Access

Counting Query
Posted by: rajah jaan
Date: March 13, 2006 07:57PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Counting Query
2076
March 13, 2006 07:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.