Data keeps alphabatizing

  • Thread starter Thread starter Jess
  • Start date Start date
J

Jess

I created a database and everytime I enter information and
then close the database, when I open it again the
information is rearranged in alphabetical order. How do I
stop my database from doing that? I want the information
in the order that I input it.
 
Include a date field, set the default to =Now() and include that field in
the query you are using as the basis for your form/report. You are viewing
the data in a form or report (not a table) aren't you?

Alternatively, create a number field and set it to increment for each new
record, then order by that field in your query.

Different flavors, same result.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Hi Jess,

Access doesn't store data in any consistent order, not even the order in
which you input it. It can however *retrieve* data in any order that you
can specify on the basis of the data itself.

Unless there's some suitable value in the table already (autonumber
fields aren't 100% reliable for this) you need to include a timestamp
field. This is just a date/time field with its default value set to
Now(). Then, to view the data in that order, just use a query sorted on
the timestamp field.
 
Back
Top