The order records are processed

[wheatonk]

I am trying to figure out how to make access process records in the order they were entered.

[pbaldy]

That's not much to go on. What do you mean by process?

[wheatonk]

I'm trying to figure overtime for a crew that works on several jobs each day. when I calculate the overtime some times it will show up on Monday or Tuesday but not on Friday. It seems to calculate records randomly?

[pbaldy]

Please remember we're not there looking over your shoulder. We have no knowledge of your application, your data structure, or the process you're using to calculate overtime. You're asking why your process isn't working correctly without showing your process.

Generally speaking, you can order by date, date/time, or if you really want order of entry, an autonumber field should work.

[Perceptus]

Possible add another column for entry date, have that column default value be =Now(). Then Modify your query to only use records based on that column value.

This is all I can offer knowing nothing of the situation.