Duplicates and a continous 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 "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
 
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
 
Back
Top