- Joined
- Feb 26, 2013
- Messages
- 12
- Reaction score
- 0
Hey all, I have created a database that I need to retrieve information from a table (linked table with another database) based on the user typing in a start date and an end date.
The original table has the date fields as text (accepts date and time).
So far I have this in the query;
>=[Start Date] & "*" And <=[End Date] & "*"
This works if the data in the original table is in the same month e.g.
if i want to retrieve data from 18/02/2013 to 22/02/2013 then it works, however if I cross over months e.g. 28/01/2013 to 01/02/2013 then it brings up a blank table without any data.
I have also worked with BETWEEN [Start Date] & "*" AND [End Date] & "*" but this doesn't seem to work either.
Any suggestions will be much appreciated
The original table has the date fields as text (accepts date and time).
So far I have this in the query;
>=[Start Date] & "*" And <=[End Date] & "*"
This works if the data in the original table is in the same month e.g.
if i want to retrieve data from 18/02/2013 to 22/02/2013 then it works, however if I cross over months e.g. 28/01/2013 to 01/02/2013 then it brings up a blank table without any data.
I have also worked with BETWEEN [Start Date] & "*" AND [End Date] & "*" but this doesn't seem to work either.
Any suggestions will be much appreciated