Can I get the answer with a query

  • Thread starter Thread starter Robert Gillard
  • Start date Start date
R

Robert Gillard

I have a table, the contents of which I show in a "continous form". How ever
the table contains duplicate records.

Idealy what I would like to happen is that each record shows once and those
with a duplicate will have a counter by the side of them to indicate how
often they appear. ( I do not want to delete the duplicate records just
count them)

Is this something I could do with a query, I have unsecsess fully tried
"Find Duplicates" and also "find Unmatched" in order to try and get the
above result. Could anybody suggest the best way to achieve this please.

With thanks

Bob
 
Start a new query on your table. Add all the fields you want. Click the
Totals button (a greek sigma) on the toolbar. Add one more field with the
expression:

NumDuplicates: Count(*)

... and change the Totals line under that field to Expression.

Note that you will not be able to update the table using this query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top