Sorting Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have created a form where users are able to enter information into the
database. However the orginal files in the document are placed in
alphabetical order, however when new records are added to the database they
are placed at the bottom of the table and are not sorted into the
alphabetical structure.

I tried going into the physcial table and sorting the records alphabetically
but to no avail.

What would I need to do to resolve this issue.

Thanks
 
You are confusing how data is stored with how data is displayed. These are
two totally different things. In a relational database (which Access is),
data is not stored in any particular order. When the data is displayed it is
your responsibility as a database developer to sort it into the sequence you
want. If you want a form to display sorted data then base the form on a query
of the table with an 'ORDER BY' clause. e.g. SELECT * from MyTable ORDER BY
AlphaKey

Dorian.
 
Back
Top