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