Report Record Order

  • Thread starter Thread starter Hiten
  • Start date Start date
H

Hiten

How can I have the most recent record entered through a
form show up at the bottom of the table and report? I'm
trying to create a report with the most recently entered
data to be at the bottom. From my checks, I don't seem to
have any filters/sorts in the report or table.
 
Hiten said:
How can I have the most recent record entered through a
form show up at the bottom of the table and report? I'm
trying to create a report with the most recently entered
data to be at the bottom. From my checks, I don't seem to
have any filters/sorts in the report or table.
Click to expand...

You would need a field or fields that will tell you which record was the most
recently entered one. This would need to be either a DateTime field that is
populated when the record is created or an incrementing number field that can
reliably indicate the newest record by virtue of it having the highest number (an
AutoNumber might not always provide this).

If you have such fields just apply a sort based on them. If you don't then you need
to add them. At the table level Access records have no internal ordering that you
can rely on.
 
Back
Top