J
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
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