Sorting a field

My OS is Win2000, version 5.0, SP3. I'm using Access 2000,
and it seems that there are only two options for sorting a
field - Sort Asending, or Sort Desending. I have a field
(Primary Key) that contains capacitor values. What I would
really like is to prevent Access from sorting this field at
all, and allow the records to retain the order in which
they were entered. Access is placing a 100pF capacitor at
the top of the list, when my 5pF cap belongs in that
position. How can I prevent Access from sorting this field?

Regards,
John

Add a field that contains a value that you can sort on. This might be a
field that defaults to Now() or an autonumber field or a field that you key
in a value.

--
Duane Hookom
MS Access MVP


"John" wrote in message
...
My OS is Win2000, version 5.0, SP3. I'm using Access 2000,
and it seems that there are only two options for sorting a
field - Sort Asending, or Sort Desending. I have a field
(Primary Key) that contains capacitor values. What I would
really like is to prevent Access from sorting this field at
all, and allow the records to retain the order in which
they were entered. Access is placing a 100pF capacitor at
the top of the list, when my 5pF cap belongs in that
position. How can I prevent Access from sorting this field?

Regards,
John