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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
query that brings a autonumber field 6
Return last record for employee 12
Unmatached in 1 Table 1
Access Dcount (multiple criteria) 3
Need a query to get rid of duplicates using two tables 1
Want last record only from a 1 to many linked table. 3
first or last of record set 5

Back
Top