Originally Posted by
June7
SELECT tblInmates.Inm_ID, [LastName] & ", " & [FirstName] AS [Names], tblOffences.OffencesName, [tblInmOff Jun].EntryDate, [tblInmOff Jun].Disc, tblInmates.DOB, DateDiff("yyyy",[DOB],Now()) AS Age, tblInmates.Address, tblInmates.Occupation, qCntInmOff.CountOfOff_pd FROM tblOffences INNER JOIN (((SELECT [tblInmOff Jun].Inm_pd, Count([tblInmOff Jun].Off_pd) AS CountOfOff_pd FROM [tblInmOff Jun] GROUP BY [tblInmOff Jun].Inm_pd) AS qCntInmOff INNER JOIN tblInmates ON qCntInmOff.Inm_pd = tblInmates.Inm_ID) INNER JOIN [tblInmOff Jun] ON tblInmates.Inm_ID = [tblInmOff Jun].Inm_pd) ON tblOffences.Off_ID = [tblInmOff Jun].Off_pd;
Now set a report sort on CountOfOff_pd field.