Table Sort

[Saida]

I'm using Access2003.
I've created a table that I'm adding,deleting, and modifying the contents of
the record in the table.
The table has three fields. Date(mm/dd/yy),PartNumber, and QuantityRequired

How can I re-sort the table in order to go to the first record according to
the sorting criteria that I specify.

Any help is appreciated

 

[Rick B]

You don't.

Tables are not user interfaces. They are simply buckets where Access stores
your data. You should not be working in the table.

To do this, create a form and work in it. You can then set your sorting
options and any other aesthetics you wish.

Rick B

 

[John Vinson]

I'm using Access2003.
I've created a table that I'm adding,deleting, and modifying the contents of
the record in the table.
The table has three fields. Date(mm/dd/yy),PartNumber, and QuantityRequired

How can I re-sort the table in order to go to the first record according to
the sorting criteria that I specify.

Any help is appreciated

Tables are unordered "heaps" of data; and table datasheets are
debugging tools, which should not be used for interacting with your
data.

To sort data in any chosen order, use a Query based on your table. To
enter or edit data, base a Form on this query.

Use the tools that Access provides - they're included for good reason!

John W. Vinson[MVP]