I am creating a query for a db I have written, and need to produce a report based on a query which asks the user to enter a date range. I have tried entering the following criteria in a query in the date field.
Between [Please enter start date dd/mm/yy] And [Please enter end date dd/mm/yy].
but this does not work, how can I get the query to work and ask the user to enter start and end dates?

ack! don't worry all sorted, it was my oversized fingers adding letters in wrong places!

you question has just helped me with the same problem, THANKS soo much