Duplicate records not showing on report

brackmannw

New member
Local time
Today, 11:18
Joined
Apr 22, 2012
Messages
3
I have created a report from a query. There are duplicate last names in the table (which is just fine). E.g., I have 2 "Hogan"s and they are different persons and I want them both to show up on the report. My query produces the correct result showing the duplicates but the report only shows 1 of the duplicates. I'm grouping on the last name (PrimaryLastName). What is the report doing to my duplicate records from the query? How do I fix that?
 
Perhaps you set "Hide Duplicates" for some controls to Yes.
 
No... Hide Duplicates is set to No. I'm wondering if this issue has something to do with grouping. The query results shows the records with the duplicate LastName field. The report does not. It has to be something in the report generation design.

Actually, one workaround might be to combine the LastName value and the primary key value. This would make a unique value even if the LastName were a duplicate. But, I don't exactly know how to do this. ?????

Thank you for your response!
 
To do what you suggested, If the primary key is called IDperson then you add to your query:
Person: =[LastName]&"," &[IDperson]
Then in your report you could add Person and group on Person instead.
 
Hi,

Rather than grouping by the "last name" you could group the report on the primary key, and just display the name on the form. You could then add a sort to order the report by the last name.

I think the key is in your initial post - you are "grouping on the last name" and therefore all like "last names" will be bundled together.
 
Concatenating the Key with the LastName did the trick!!

Thank you so much everyone for helping me!!
 

Users who are viewing this thread

Back
Top Bottom