Date criteria using between and form date picker

[killermonkey]

I'm trying to set up the criteria on a query based off the values in two date picker text boxes on a form. It works beautifully like this



Between [Forms]![Daily]![cboSDate] And [Forms]![Daily]![cboEDate]

However I would like all the dates in the query to show up if the the date pickers are left blank.

I've tried this

Between "*" & [Forms]![Daily]![cboSDate] & "*" And "*" & [Forms]![Daily]![cboEDate] & "*"

but get an error every time.

Any suggestions as to what I might be doing wrong?

Thank you in advance,

Tyler

[pbaldy]

Your syntax is off, but I don't think that method would work with dates anyway. Try

Between Nz([Forms]![Daily]![cboSDate], #1/1/2000#) And Nz([Forms]![Daily]![cboEDate], #12/31/2029#)

or other dates appropriate to your needs.

[killermonkey]

Paul,


That worked perfectly, thank you for your help.


Regards,

Tyler

[pbaldy]

No problem Tyler.