Duplication Problems

[mhelmrich]

I have a database for Agent Performance reporting. There are a few agent that have the same last name. The problem I am having is that when I come across 2 agents with the same last name, the report will not list both agents. I have turned off the "Hide Duplicates" Property of the text box, as well as make sure the table I am reporting on will allow duplicates... Not sure what to do to make it work. I currently have to slightly alter the name, which is frowned upon by management.

 

[andyski101]

Do you have employee id's or some form of primary key?

 

[mhelmrich]

Yeah, I have the EMP ID's indexed. The Agents Last name column was indexed as well, but I have since removed the index from the Last Name.

 

[DanG]

1st employee# must be in the query/table the report is based on. Then in the report on the toolbar look for the "Sorting and Grouping" button and reference Employee# there and in that box you can set up you grouping requirements (Header, footers and all that stuff).

 

[ScottGem]

If you want to sort on Employee then grouping on EmployeeID won't work for you. In the query the report is based on (if it wasn't based on a query change that) add a column with an expression like:

FullName: [Lastname] & ", " & [Firstname]

Use that column for the grouping in your report.