I did, sorry, I posted a reply that included the SQL back to John Spencer but
I may have done it wrong and posted a general comment so I'll try again.

"golfinray" wrote:

In your query criteria, try Between [ ] and [ ]
--
Milton Purdy
ACCESS
State of Arkansas


"GovCoder" wrote:

Okay, I've read and tried dozens of articles and suggestions about how to use
parameters, how it's done, and every time I try something, is comes up as not
working. It's a report driven by a parameter driven query. The way the
parameters are produced is to assign VBA date values to text boxes on a form,
from which the query reads the parameters using something like...

forms!frmReports!txtFirstBegin.value

I've been trying to use the Between And operator since I have two dates. It
seems to never work. I even tried entering parameters into the parameter
screen on the query, didn't work. I've tried a where variable on a
DoCmd.OpenReport statement. Didn't work. Does this even work anymore with
Access or has Microsoft made it impossible to do this now?