Correct Syntax for Between Dates Criteria in Query 2

[gallas]

I'm trying to collect two date values from text boxes on a form and then set these as the start and end dates for query criteria. I can't seem to get the syntax right. I'm building it in the Access query design grid. Here is an example.

Between "#" & [forms]![frmQuoteRptChoice]![StartDate] & "#" And "#" & [forms]![frmQuoteRptChoice]![EndDate] & "#"

Any Ideas?

"If a job's worth doing, it's worth doing twice!"

 

[Crowley16]

if the controls are already set to date format then you don't need any of the & or #

only add them in if the control is set to text

--------------------
Procrastinate Now!

 

[jebry]

Hi!

If the fields referenced by the text boxes are formatted as date/time then you need to get rid of the # signs.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[gallas]

Thanks guys, that works fine. Odd because that's what I thought I tested originally - must have made a small un-noticed typo. Stars all round!

Thanks again.

"If a job's worth doing, it's worth doing twice!"