Search results

Concatenating the Key with the LastName did the trick!! Thank you so much everyone for helping me!!

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...

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...