Last 100 records

  • Thread starter Thread starter Somecallmejosh
  • Start date Start date
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
 
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.
 
Back
Top