I am using Access 2010. I am trying to get my report
The string varaible "ReportFilter
" evaulates as follows.
"[Date of Sale] between #01/05/2013# and #31/05/2013#"
Dim ReportFilter As String
ReportFilter = "[Date of Sale] between #" & TheDates(0) & "# and #" & TheDates(1) & "#"
DoCmd.OpenReport "rpt PDC Sales by Date", acViewPreview, , ReportFilter, OpenArgs:=strInfo
I am trying to control the beginning and end dates for this report (as you can see). The date criteria seem to have no effect on my report output.
I would appreciate any help.