Report grouping incorrectly

[tmarsh]

I have a report based on a query that is grouped by job title and ordered by surname/name in a staff training database. Problem is if there are 3 john smiths it shows one only but correctly lists training for 3.

What have I done wrong?

Thanks.

 

[tmarsh]

I have a report based on a query that is grouped by job title and ordered by surname/name in a staff training database. Problem is if there are 3 john smiths it shows one only but correctly lists training for 3.
.

I've just noticed that it does the same for same last name but differing first names e.g. john smith, fred smith.

 

[tmarsh]

I have a report based on a query that is grouped by job title and ordered by surname/name in a staff training database. Problem is if there are 3 john smiths it shows one only but correctly lists training for 3.

What have I done wrong?

Thanks.

Figured it out. I hadn't included the primary key.