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
 
Back
Top