Duplicates and a continous form

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

Could anybody suggest the best way to achieve this please.

With thanks

Bob

 

[MacDermott]

This can be done using a Totals query - q.v. in the Access Help file.
However, the data will not be updatable.
So there is little value in displaying it in a form.
You might consider using a report for this.

HTH
- Turtle