Duplicate Records

[saintsman]

I tried searching but without success.

How do you produce a list in a form that will display one duplicated record as well as non duplicated records?

Thanks in advance.

 

[dcx693]

A bit confused here.

Do you mean you only want a list of unique records? Or do you mean display a max of 2 duplicated records, but no more? Maybe you should post an example.

 

[saintsman]

What I wish to do is list all my records, but where there are duplicates, only show one of them. IE if I have a list that would produce 10 records and three of them are duplicated I would end up with a list of 8 records. The remaining 2 duplicates would not be shown.

 

[dcx693]

You might want to fix the underlying problem and get rid of the duplicates, but if you want to keep them....

Base the form on a query (if you're not doing that already), and in the query properties sheet (if it's not visible go to the View menu and choose Properties), change the "Unique Values" field to Yes.

 

[saintsman]

Unfortunately I need to keep them.

I will give the Query a go. Thanks very much for your help.

 

[Shadez]

Just a side note

What you are realy doing is changing the sql of the query to inclue the

Distinct

or

Distinct Row

Syntax

[i]IE,[/i]
SELECT DISTINCT SomeField FROM SomeTable