Duplicates in a continuous form

  • 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 "continuous form". How
ever
the table contains duplicate records.

Ideally 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)

Could anybody suggest the best way to achieve this please.

With thanks

Bob
 
Robert

Base the recorsource of the form on a "Totals" query. Might look something
like this.

SELECT Count(YourTable.FieldThatIsUniqueKey) AS Count,
YourTable.FieldwithDupes AS Descr
FROM YourTable
GROUP BY YourTable.FieldwithDupes
ORDER BY YourTable.FieldwithDupes;

Ron W
 
Back
Top