For 'Yearly':
=DCount("*","[Yearly]","[Status] = 'Active' AND [MemberType] = 1")
For 'Three Year':
=DCount("*","[Yearly]","[Status] = 'Active' AND [MemberType] = 3")
For 'Life Time':
=DCount("*","[Yearly]","[Status] = 'Active' AND [MemberType] = 2")
These commands above lets me do what i am trying to achieve. Since i
have two type of reports that i run with a parameter (yearly, three
year, lifetime) this command will work with one of member type only.
If i were to type this behind a textbox and when i open report and it
asks to type the parameter after I choose yearly I get the right total
but if i were to choose lifetime or three year i see yearly totals
instead of lifetime or three year.
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/
