Displaying data in order entered

[Bobbye]

I have a time sheet report that list hours worked for various jobs for each
employee each day. At the end of the pay period the supervisor checks the
reports and makes any necessary corrections. I then edit the records and
check the old sheet against the new print out to be sure I did it right. My
problem is, the record order has changed on the new printout and checking the
corrections is made unnecessarily difficult. Example:

Emp#1
reg ot dbl rec#
2/3 3 4 1 1
2/3 4 2
2/3 2.5 3
2/4 8 4
2/5 6 5

If I edit record #3 I get :
reg ot dbl rec#
2/3 2.5 3*
2/3 3 4 1 1
2/3 4 2
2/4 8 4
2/5 6 5

I would like it to stay in it's original order. Is there something I can do?

 

[Douglas J. Steele]

You cannot (or at least should not) make any assumption about the order of
records in tables in relational databases.

If you need to ensure their sequence, you need to have a field (or fields)
that you can use in an Order By clause in your query. If you're talking
about the order of records on a report, note that the order of the
underlying query doesn't usually matter: reports determine the order of
records from what's set in the Sorting and Grouping box.

Try adding a date/time field to your underlying table (calling it something
like EnteredDTM) and set its default to Now. That will populate the field
with the date and time that it was entered, and you'll be able to order on
that field.

 

[Bobbye]

Thanks. I have an autonumber field (ID) that tracks each record I enter.
(This is the number I use to edit a record). On the report I was able to
sort/group ascending on this number so that it always printed in a consistent
order.
--
Ameteur Access 2000 User
Thanks Bobbye

You cannot (or at least should not) make any assumption about the order of
records in tables in relational databases.

If you need to ensure their sequence, you need to have a field (or fields)
that you can use in an Order By clause in your query. If you're talking
about the order of records on a report, note that the order of the
underlying query doesn't usually matter: reports determine the order of
records from what's set in the Sorting and Grouping box.

Try adding a date/time field to your underlying table (calling it something
like EnteredDTM) and set its default to Now. That will populate the field
with the date and time that it was entered, and you'll be able to order on
that field.