--- Hassan <[EMAIL PROTECTED]> wrote: > 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! > Okay that helps clarify it some and perhaps for someone else it might even ring that ole bell but for me I'll have to ask another question.
You say the "dcount function counts them fine but separately"... I am not overly familiar with that specific function so do not understand what you mean by "fine but separately". On a counter note -- I have worked with reports where you want a final count value to show up at the top of a report. This only works if the report has a 2 pass through process (not sure if MS Reports does). In this case you can put the count at the bottom using a hidden field and then reference that hidden field at the top of the form. Just in case that is what you are trying to accomplish. __________________________________________________ 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/
