Between dates criteria in query

[Frank72]

Hows it going

simple question here i think.. im trying to run a report based on a query which uses 2 text box entries on a form as a criteria for a field 'DateCustDetailsEntered', i've put this in the criteria box

<// Between [Forms]![frmCustDetails]![txtDateFrom] And [Forms]![frmCustDetails]![txtDateTo] //>

and the query is coming up blank, is this syntax wrong?
how do i use two text boxes to get a date between?

thanks alot

frank

 

[Ed2020]

Frank,

Just a thought - text boxes don't contain dates. They contain text strings. Try:

<// Between CDate([Forms]![frmCustDetails]![txtDateFrom]) And CDate([Forms]![frmCustDetails]![txtDateTo]) //>

Ed Metcalfe.