using count in a query

[Jake]

I have a query that I am using to show all records in a table, based on a
couple criteria. One of the fields in the query [MEMBER ID] has data the
repeats. I want to leave everything the way it is and add to this query a
count of how many times a value in this field shows up in the table. I am
able to do this if I only put [MEMBER ID] in a query twice, make it a totals
query, and leave one on group by and put the other on count. When I try to
just add [MEMBER ID] to my original query a second time and change one of
them to count in the same way, the value for the count field will only show
as 1. any ideas?

thanks

 

[Jake]

I figured this out; if it will help anyone, this is what I did:

I just added the count query that actually works (with just the one field
shown twice) to the shown tables in my original query. I then added the
count field from this count query to the grid in the original query and
linked the common field [MEMBER ID] between the table and the count query.
works good