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.

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

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.

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

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.