Re: Date convention
Like Jim P I have never had any problem sorting dates with access provided they are entered as dates (the data field set to date) and not entered as plain text which does create problems when filtering and sorting.
Also when the date is entered as a date (and not a text string) then you can adjust the date format to whatever you like and it automatically updates the format of every date in the field.
Regards
Andy Fletcher
|