Jean has attended:
Access Introduction course
Query
how do I make a query to search for a record such as dates between 10/07/2010 and 31/10/2010?
RE: query
Hi Jean,
Thank you for your question.
In the criteria line of the query underneath the date field add the following:
Between 10/07/2010 and 31/10/2010
Then view the datasheet to see the results.
I hope this answers your question. If it does can you please mark it as complete.
Regards
Simon
RE: query
I'm afraid this isn't working - it's bringing up more dates than between 10/07/2010 and 31/10/2010, so I haven't marked it as resolved.
Best,
Jean
RE: query
Hi Jean,
Thank you for your response.
There could be two issues:
1. Are the dates in US format or UK format?
2. What is the format of the date ie. using slashes or dots or another format?
Regards
Simon
RE: query
Hi Jean,
I have just had another thought.
The data in that column may not be in date format as the criteria I gave you will work on dates.
It sounds like the data is being read as a text string.
Regards
Simon
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.