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

[Guest]

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!!

 

[Dirk Goldgar]

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.

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?

 

[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!!

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

 

[Walter Piper]

Sorry, I got distracted and did not get back to you for 7 years!

The field truly is a date/time field. That is, I go to Design View in the table and it lists "Date/time" as the format under "Data Type". I understand that string fields masquerading as date fields do not sort well. I do not think that is my problem here.

I appreciate the help. Not sure we have found the problem yet. Shouldn't it be a piece of cake for Access to sort a date/time field chronologically?

Sorry if my primitive knowledge of Access is causing me to miss something fundamental!

wp

 

[Walter Piper]

BTW, Access sorts the single date/time field perfectly when I have selected only that field to sort. The problem comes about when I try to sort two fields at once, one a text field and the SECOND the date/time field. Yet I have carefully used the ctrl ' shortcut to copy the content of each record in the text field precisely to the record below -- thus, I know that the entries in the sorted text field are identical.

wp