filter last five rows in a table using query builder in MS access

A

Allen Browne

Sort in DESCENDING order on the field(s) that defines what your last 5
entries are.

Open the Properties box, and looking at the properties of the query (not of
a field), set the Top values to 5.
 

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 Change criteria on a saved query using VBA 0
Append Crosstab Query to Existing Table 0
Save last item copied 0
Delete all data after a symbol in a field 0
Sharing Access MDB or Accdb with client using older or newer version of Office 1
Sorting Multiple Tables 1
Query the same table three times 0
Dates In Excel 5

Top