Duplicates in a continuous form

[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

 

[Ron Weiner]

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