Using unbound form data in query not working

[Perceptus]

I am trying to use 2 forms unbound textboxes to limit what data is viewed on a query. I have tested in my immediate window

?[forms]!reportlist.form.txtStart
1/1/2013
?[forms]!reportlist.form.txtend
5/1/2013

However when I use in my query

Select * from tblentries where tblentries.bdate >= [forms]!reportlist.form.txtStart and <=[forms]!reportlist.form.txtend

Bdate is always a date.

I get data that falls outside the window im looking for.

Is this an incorrect way to reference and restrict data?


Thank you for your time

[June7]

Dynamic parameters in query are possible, just your syntax is wrong. Try:

Select * from tblentries where tblentries.bdate BETWEEN Nz([forms]!reportlist.txtStart, #1/1/1900#) AND Nz([forms]!reportlist.txtend, #12/31/2900#)

The Nz() function allows the query to still work if users neglect to input criteria.

However, I NEVER use dynamic parameters in query. I prefer VBA to set Filter and FilterOn properties of form. Review: http://allenbrowne.com/ser-62code.html

[Perceptus]

Ah BETWEEN!. I didn't even think of that.

Is there any benefit to converting the dates to a long and doing the similar?

[June7]

I've never done that so I guess my answer is No.

[Perceptus]

Thank you for your help =).