Hi all,
I currently have a query designed to return the records for a range of dates.
Criteria:
Between [Enter Date] And DateAdd("d",1,[Enter Date])
The main problem with this is that the user enters the data in dd/mm/yy, but the system records it as being mm/dd/yy instead.
Is there any way to get Access to accept this as dd/mm/yy?
I currently have a query designed to return the records for a range of dates.
Criteria:
Between [Enter Date] And DateAdd("d",1,[Enter Date])
The main problem with this is that the user enters the data in dd/mm/yy, but the system records it as being mm/dd/yy instead.
Is there any way to get Access to accept this as dd/mm/yy?