Filtering Duplicate Values in a Query

D

droyer

I am trying to find the total number of bank accounts for each month. The
table I am working with has a card number and a transaction date. I group by
card number and then trans action date which gives me the date of each trans
action and each card number for the corresponding date of the transactions.
I want to filter the data so that the card number lists only once so I can
total the number of accounts for each month. Someone please help!
Thanks
 
D

Dennis

Create an initial query with no groupings that shows the card numbers and the
transaction dates in the range that you require. Create a 2nd query based on
your initial query, select just the card number field and group on it.
 
Top