Table Sort

  • Thread starter Thread starter Saida
  • Start date Start date
S

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
 
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
 
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
Click to expand...

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]
 
Back
Top