Information showing in tables

[duchessofireland]

Does anyone know how to get my information in my tables to display by "order
date". I have a field called "order date" in my table. I'd like to be able
to open my table in datasheet view and be able to see my information that I
entered in a specific manner...that being in chronological order entered into
the "order date" field. Thanks so much!

 

[fredg]

Does anyone know how to get my information in my tables to display by "order
date". I have a field called "order date" in my table. I'd like to be able
to open my table in datasheet view and be able to see my information that I
entered in a specific manner...that being in chronological order entered into
the "order date" field. Thanks so much!

!) Never allow anyone to 'view' your table. Tables are designed for
data storage, not viewing.

2) Always display data via a Form.
Base the Form on a query that contains all of the fields you wish to
show.
Set the [OrderDate] column to sort Ascending.

You can then open the form in Datasheet view (if that's how you wish
to see the data) and it will be sorted by [OrderDate].

 

[AndyB via AccessMonster.com]

Hi There,

As fredg said, it's bad practice to permit viewing of your data in datasheet
view. Far too easy for inadvertent changes to be made.

However, if it's only you wishing a quick overview of your data in date order,
open your table in datasheet view, find your order date column, click on the
column name at the top of the sheet and the column will be highlighted.
Now click the Sort Ascending button on the toolbar (That's an A-Z with a Down
Arrow).
Close the table & you'll be prompted to same the table design.
Save changes & every time you open the table in datasheet view, your data
will be sorted accordingly.

Not good practice, but useful on occasion.

If other persons are likely to access this table, a simple work-around would
be to create a Select Query based on the table, sort the order date ascending
and change the RecordSet Type from Dynaset to Snapshot.

Others could now view the table thru the query, but not be able to make
changes.

Andy
Andy