Date Range Syntax Error

[LysaTigger]

Hi,
I have a syntax error and I don't know how to fix it.
I am trying to filter a report based on a date range.
Here is the code that I have attributed to a cmdbutton in a form to filter the report based on a date range.

DoCmd.OpenReport "rptRequestDate", acViewPreview, , "[StartDate] >= #" & Me![txtFromDate] & #" and <= #" & Me![txtToDate] & "#"

Please let me know where the syntax error is.
Thanks,
Lysa

 

[RoyVidar]

What is less than or equal to the txtToDate control? The same date field?

[tt]"[StartDate] >= #" & Me![txtFromDate] & #" and [StartDate] <= #" & Me![txtToDate] & "#"
[/tt]

Roy-Vidar

 

[PHV]

DoCmd.OpenReport "rptRequestDate", acViewPreview, , "[StartDate] Between #" & Me![txtFromDate] & "# and #" & Me![txtToDate] & "#"


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LysaTigger]

Thanks PHV that works. Have a nice day