Data Entry/Maitainence in MS Access

A

access newbie

I am uploading data into a MS Access program. I wish to make my data appear
at the top of the listings.The only way I have found to do this is to put an
exclamation mark (!) as the very first character. To save me from having to
put endless exclamation marks at the start of data entries is there a way i
can use hidden characters or a simple macro to be at the top of listings all
the time?

Any advice will be appreciated, Newbie.
 
J

John Vinson

I am uploading data into a MS Access program. I wish to make my data appear
at the top of the listings.The only way I have found to do this is to put an
exclamation mark (!) as the very first character. To save me from having to
put endless exclamation marks at the start of data entries is there a way i
can use hidden characters or a simple macro to be at the top of listings all
the time?

Any advice will be appreciated, Newbie.
Click to expand...

Are these "listings" your table datasheets? reports? forms? or what?

Note that an Access Table HAS NO ORDER. It's a "heap" of data; it's
usually displayed for your convenience in Primary Key order but
there's no guarantee that you'll always see it that way.

I would suggest that you include a sequential Autonumber field, or a
date/time field with a default value of Now(), in your table. Append
your uploaded data into this table, and use a Query sorting by this
additional field in descending order, in order to see the most recent
record first. Base a Form on this query to display and edith the data
(table or query datasheets are of very limited utility).

John W. Vinson[MVP]
 
Top