Question I'm trying to add a row count...

[alexfwalker]

I'm trying to select the most recent record in a query.

I can't use all the Group By functions, or max, first etc because the rows have different information in the columns which seems to negate this function - in other words Access can't collapse the rows effectively because the information differs.

My database imports data periodically about consignment numbers, which it stamps with a date and time. The query is sorted in descending order by date and time, but I just need to see the most recent entry in each case, as a consignment number may have many status updates, but I'm only interested in the most recent.

What I thought I could do is number each entry 1,2,3,4,5 etc, then set another query to only show the 1s, but I don't know how to write the counter so that it numbers, then at each change in consignment number starts numbering again! Any ideas?!

Thanks,

Alex

 

[vbaInet]

The query is sorted in descending order by date and time, but I just need to see the most recent entry in each case, as a consignment number may have many status updates, but I'm only interested in the most recent.

This should have been your question. Let's see what your data looks like. Sample data not confidential data.

To answer your original question, it can be done easily in a report.