Sorting a field

[John]

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

 

[Duane Hookom]

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.