Access Forms - not picking up date in txt box for query

[as323]

Hi,

Im fairly new to Access and have been working on a query where there are records located for clients against activity that that they have done on certain dates and time.

The records appear in a query that is used by relating multiple tables to locate records bewtween two date periods. When I put in the criteria for the ClientDate between dd/mm/yyyy and dd/mm/yyyy the query works fine and the correct number of records are pulled up.

My problem stems from having a front end which is setup similar to a dash borad where when the front end is opened you have two unbound text boxes which are start date and end date. A button is on the front end to run the query.

I have then added: >=![froms]![Formname]![txtStartDate] and <=![froms]![Formname]![txtStartDate] two get the date ranges entered in the text boxes. no records appear and I cannopt figure out why even when I have set the input mask to dd/mm/yyyy:0;_ and format to short date.

Please help urgently?

 

[Dennisk]

input formats are irrevant as all date/times are stored as a number.

You can use the BETWEEN keyword in your criteria, but you are only using one text box

for simplicity

BETWEEN txtStartDate AND txtStartdate,

so only recordswith that one date will be retrieved.

 

[as323]

I am using two text boxes on the form which is start date and end date. and the dates entered on the form need to fall into the criteria of the clientDate of between "start date" and "End Date"