I have only two reports that I run using this query, members by
MemberID and by LastName.
SELECT Members.*, MemberTypes.MemberType AS MemberTypeDesc
FROM MemberTypes INNER JOIN Members ON MemberTypes.MemberTypeID =
Members.MemberType
WHERE (((MemberTypes.MemberType)=[Yearly, Three Year OR Lifetime]) AND
((Members.Status)="Active"));
As I open report it prompts for yearly, lifetime or three year and
whichever one I type I get the necessary records accurately. On top of
that report I have a text box that counts the total number of members
of whatever membertype I retrieve (lifetime, yearly or three year). All
I want to know is the total number of members active in yearly,
lifetime or three year, depending upon what I type.
Any ideas?
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> 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/
