Counting

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I need to know if a name or account number or address
appears more than once in a VERY LARGE database. I cannot
assign a value to search for -- I need to know if any
appear more than once.
 
Dear Karen:

Use an aggregate ("Totals") query something like this:

SELECT AccountNumber, COUNT(*) AS AccountNumberCount
FROM YourTable
GROUP BY AccountNumber
HAVING COUNT(*) > 1

This will show all the Account Numbers that appear more than once, and
the number of times each appears. You can substitute Address for
AccountNumber and it will do addresses.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top