date range in a query

[wshs]

i have a query which consists of 3 criteria
PRnum, =[forms]![frm1_purrequisition]![txtpr]
Payee, =[forms]![frm1_PurRequisition]![payee]
Date,

I have "fromDate" and "toDate" on the form and i don't know how set the criteria to return all the records inbetween those dates... how would I do that?

---------------------------------
event of search cmd button.

DoCmd.OpenForm "frm1_PurRequisition", , "qry_PurRequisition

 

[PHV]

Date, Between [Forms]![frm1_PurRequisition]![fromDate] And [Forms]![frm1_PurRequisition]![toDate]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wshs]

between.. i see. thank you ph