I have created a DB in Access 2000.
The Date Field (clientdate) is currently a MEMO field.
The date is being entered as:
10 June 2004
21 January 2005
09 September 2004
How would I display this in Date order ?
I have tried changing the field type to Date/Time, and setting it to long
I'm using an SQL Query to select Name, Address and Date from the DB (this
I've added 'Order By clientdate' this works but the date is displayed as:
Not the long date format !
How do I get it ...