Are you saying you are not getting the total and wnat to? Or you don't know how to get the total to display on the top of your report?
I ask because from what I see that is what you should be getting as result. --- Hassan <[EMAIL PROTECTED]> wrote: > 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. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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/
