Report printing duplicate records

[Leventcos21]

Hello,

Iam trying to print out a report that is derived from a form and subform (contains 1 or 2 names).

When I go to print it out I will get duplicate records if there are multiple names selected in the subform. How can I prevent this from happening. Is there a way that I can only print the first subform record and not show the second record in the subform.

example,

record 1 - john doe
record 2 - may doe
record 2- john doe ( I don't want this record to show)

Thank you,

 

[Banana]

Base your report on a query instead, and make sure it is set to show Unique Records. That can be found in query's properties.

 

[Leventcos21]

I am pulling it from a query, and selected Yes for unique records but I am still getting duplicates.

 

[RV]

I am pulling it from a query, and selected Yes for unique records but I am still getting duplicates.

Normally that means that indeed your rows are not unique.
I'd run your query, and have a closer look.
For instance, if you've got any autonumber column included in your query, then you won't have any duplicate rows as each autonumber is unique.

RV

 

[Pauldohert]

Set up a query that brings out the first (only one) name per company as would be deispalyed on the subform.

Then join this info to the company info - to produce one line per company no matter how many names there are in the subform.

So something like

SELECT DISTINCT First(ContactNames.ContactNameID) AS FirstOfContactNameID, ContactNames.OrganisationID
FROM ContactNames
GROUP BY ContactNames.OrganisationID
ORDER BY ContactNames.OrganisationID;

(where contactnames is whatever the data is for your subform)