Access Access Date Parameter Query

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 :)
 
Back
Top