Last record(s)

  • Thread starter Thread starter robejohg
  • Start date Start date
R

robejohg

I have a sub-form that lists details of an event. I need
the sub-form to list the last 5 records.

Any ideas?

Thanks
 
robejohg said:
I have a sub-form that lists details of an event. I need
the sub-form to list the last 5 records.
Click to expand...


What do you mean by "Last"?

If you mean the most recently entered records, then the
table will have to have a field (date entered?) that can be
used to determine the order that the records entered. With
such a field, you might be able to use a query like:

SELECT TOP 5 table.*
FROM table
ORDER BY dateenteredfield DESC
 
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

see last 'n' records on screen, but don't sub-set data 3
Access Form Refresh 1
Locate record in a subform 1
Problems adding new record from form / subform 6
Multiple subforms 0
Duplicate sub form last record 6
Need combo box to refresh when moving to new record 2017 1
Automatic Save when leaving a tab page? 14

Back
Top