Retrieving the 5 most recent records from a table

[hbrems]

Hello,

I have a table with part orders and I want to retrieve my five most recent orders in a query. That means I'll need the 5 most recent orderids How would I mention that in my criteria?

Kind regards,
Hans

 

[MStef]

Hello Hans!

Look at "Demo5MostRecentA2000.mdb"
I think it is what you need. Look at Table1, Query1.
Start Query1.