report sort problem

[reknox]

Using Access 2003, have query that sorts by last name and first name correctly. The report that was designed using the query won't show the name (first or last) if it is a duplicate. The report sort/group box has the name fields. The table is indexed and allows duplicates. Any suggestions appreciated.

 

[SOS]

A report doesn't use the sort from the query. You need to set the sort you want in the Sorting and Grouping section of the report.

 

[reknox]

Thanks but I stated that was done in the original post.

 

[SOS]

Can you upload a screenshot of the report in design view with the Sorting and Grouping showing. (upload here and not to a public photo sharing site as those are blocked for me at work)