Last 100 records

S

Somecallmejosh

I am trying to create a query that shows the last 100
records entered into a table. Is there an expression I
can write in the criteria field that will allow me to see
only the last 100 entries?

Thanks a lot,
Josh
 
D

Douglas J. Steele

No, but if you sort them in descending order, you can select the TOP 100.
Using the GUI interface, look at the query's Properties page and set the Top
Values field to 100.
 
Top