Filtering Duplicate Values in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top