I am trying to get the total number of members on top of my report in a
textbox.
I have different member types in my database,
I have two types of reports to run for each member type, I have a
simple query setup which prompts for membertype in my report which lets
me retrieve (yearly, three year, lifetime)after typing any membertypes
i get the desire results.
All i wanted to know is how many members are pulling up on my report
for example if i have 400 yearly members then i should see 400 on top.
I have 400 yearly, 70 lifetime and 25 three year members. I have tried
the query with dcount function and it counts them fine but seperately,
how can i make a query which will count the member type i am trying to
retrieve??
I hope i am clear enough!
Thanks
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
