Query Latest Status

[joejambul]

Hi, everyone. This my first thread. I am noobies in access. Just started to lear a month ago.
I have a question about queries. I already try searching any thread but not same as mine.
I am making a database that will recorded the status of the Order. I have this table

StatusID OrderNo Status Time 1 abc123 Process 8:00 2 def456 Process 8:15 3 fgh678 Process 8:30 4 def456 QC 8:45 5 abc123 QC 9:00 6 def456 Process 9:10 7 abc123 Packing 10:00 8 def456 QC 10:30

I would like the query to show only the latest status of the OrderNo
and "Frequencies of QC" like below

OrderNo LatestStatus Freq of QC Latest Time def456 QC 2 10:30 abc123 Packing 1 10:00 fgh678 Process 8:30

Please assist me here. I am very lost right now.

[June7]

Seldom will you find anything exactly same as yours but can be close.
For a similar situation, review https://www.accessforums.net/reports...tax-38123.html