[AccessD] Putting Dates in Order

I am using Right([DateRequested],4). Since some of the records were imported
from a Word file (what was used as the log previously), the DateRequested
dates do not have the date & time, they show the time as 12:00:00 AM. I have
DateRequested as a Date/Time showing the time requested along with the date.
I am getting the year on most of the them, but the new records show 9 AM or
3 PM (which would be the last 4).
 
Virginia

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
Sent: Saturday, February 08, 2003 8:49 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Putting Dates in Order


Is there anyway to get dates in order? 
 
I try Ascending & get:
 
01/01/2001
01/01/2003
02/01/2001
 
I want:
01/01/2001
02/01/2001
01/01/2003
 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030208/c605144f/attachment-0002.html>