Message prompted date query criteria

[qrysonqrysgirlsongirls]

I am trying to run a report based on user entered start and end dates. The query is based on another query that first outputs max values on completed dates.


The second query runs just fine when I put the start/end dates directly into the criteria but I need the report to be based on user choosen dates. I am using [Start Date] and [End Date] in the criteria to generate the prompts. The query runs using the prompts but I get dates outside the min/max parameters.

[June7]

I don't use parameterized queries. I use VBA to construct filter criteria and pass to report when opening.

DoCmd.OpenReport "report name", , , "[datefield] BETWEEN #" & Me.tbxStart & "# AND #" & Me.tbxEnd & "#"