Hi all - I'm having some trouble getting a report to sort data the way I need it to in Access.
I have a database:
I've generated a query to get back the cases of all people who have a certain role.
SELECT tbl_PersonName.PersonName, tbl_Role.RoleType, tbl_CASE.CaseName
FROM tbl_Role INNER JOIN (tbl_PersonName INNER JOIN (tbl_CASE INNER JOIN tbl_PersonRole ON tbl_CASE.CaseID=tbl_PersonRole.CaseID) ON tbl_PersonName.PersonNameID=tbl_PersonRole.PersonNameID) ON tbl_Role.RoleID=tbl_PersonRole.RoleID
When I generate a report, I'm getting the list alphabetically, by person name. What I need is the list sorted by people with the most cases at the top. Any thoughts?