Why does MS Access fail to sort a date in proper order?

L

loon guy

I enter data into a Ms-Access, using two fields, one for name and a second
for date. Then I select both name and date fields and click on the AtoZ
button for sorting. For some reason, it fails to sort by date the last record
I entered for a given name. Instead, it lists the record as the first for
that name but has the date out of sequence.

Help!!
 
D

Dirk Goldgar

loon guy said:
I enter data into a Ms-Access, using two fields, one for name and a
second for date. Then I select both name and date fields and click on
the AtoZ button for sorting. For some reason, it fails to sort by
date the last record I entered for a given name. Instead, it lists
the record as the first for that name but has the date out of
sequence.
Click to expand...

Is your date field actually a date/time type of field? Or is it a text
field that you've just put a date-formatted string in?
 
J

John Vinson

On Tue, 30 Nov 2004 10:23:05 -0800, "loon guy" <loon
I enter data into a Ms-Access, using two fields, one for name and a second
for date. Then I select both name and date fields and click on the AtoZ
button for sorting. For some reason, it fails to sort by date the last record
I entered for a given name. Instead, it lists the record as the first for
that name but has the date out of sequence.

Help!!
Click to expand...

Three suggestions:

- Don't try to sort Tables, or use table datasheet view for much of
anything except debugging.
- Create a Query based on your table; select the sort fields left to
right, first prioity sort first. Base your Form on this query rather
than on the table.
- Be sure that the date is in a Date/Time field, not Text.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top