I am only just familiar with MSAccess.
I am having to maintain someone else's Access application.
One screen with date input fields returns an error.
These fields ( start and end date) are input to a query.
I can run the query manually and enter 01 02 03 and 01 01 07 when prompted ( by experiment) and the query runs.
the inputs are in the form day month year
What expression should I have in the Format property on the form.
I've tried / and \ and \/ etc without success.
Many thanks
William
I am having to maintain someone else's Access application.
One screen with date input fields returns an error.
These fields ( start and end date) are input to a query.
I can run the query manually and enter 01 02 03 and 01 01 07 when prompted ( by experiment) and the query runs.
the inputs are in the form day month year
What expression should I have in the Format property on the form.
I've tried / and \ and \/ etc without success.
Many thanks
William
