Sorting

[Guest]

I have an Access database I created. They key fields of a particular sort
are the "employee number" and the "Hours Worked YTD Total." I have created a
query that sorts in ascending order based on the "Hours Worked YTD Total"
field. This query works but on a periodic basis all entries of hours worked
must be set to zero and the employee sort order must remain in the same order
prior to zeroing the hours.

 

[John Spencer]

The only way to do that would be to retain the data. Perhaps instead of
deleting the data you could move it into another field and use that
field for your sort until you were ready to use the hours worked field
again.

Records in TABLES do not have any intrinsic order. If you want a
specific order use a query (or a report) and set the desired order
there. That is the only way to reliably have the records in any
specific order.


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

Thanks for the help.

The only way to do that would be to retain the data. Perhaps instead of
deleting the data you could move it into another field and use that
field for your sort until you were ready to use the hours worked field
again.

Records in TABLES do not have any intrinsic order. If you want a
specific order use a query (or a report) and set the desired order
there. That is the only way to reliably have the records in any
specific order.


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================