Access - sort/order by after a query has been grouped - subquery??

[cafulford]

Hi, I have an existing query (

http://aearo2.com/tmp/qrySelectTrailersExplained2.jpg)

that I would like to sort by the date/time the record was entered into the table bl_file that feeds this query. I have a date/time field called TIME_REC_CREATED.

I added this new field TIME_REC_CREATED to the group by but because my group that is actually the "key" used in a subsequent print routine, it messed up the group which is only supposed to be carrier/trailer # so what I need to do is be able to keep the group the way it originally was, then be able to sort by TIME_REC_CREATED within that group. I have been researching for a long time and I think "maybe" a subquery would work but I have tried all sorts of iterations and can not come up with proper syntax.

I am still learning Access so the more detailed an answer you can give, the better.

Please see

http://aearo2.com/tmp/qrySelectTrailersExplained2.jpg

for record layout. The existing query is:

SELECT CARRIER_NA & TRAILER_NU & " ( " & Count(*) & ")" AS Display, bl_file.CARRIER_NA, bl_file.TRAILER_NU
FROM bl_file
WHERE (((bl_file.BL_NUM) Is Not Null) AND ((bl_file.PRINTED)=0))
GROUP BY bl_file.CARRIER_NA, bl_file.TRAILER_NU
HAVING (((bl_file.CARRIER_NA) Is Not Null) AND ((bl_file.TRAILER_NU) Is Not Null));


Thanks in advance for your help!