selcting report criteria

  • Thread starter Thread starter alan
  • Start date Start date
A

alan

I am using the followinc code to produce a report but need
to set the criteria to select entries between two dates
which are Dim StrtDate and Dim EndDate earlier in the
code. How should these be descibed in the last section of
this line?

DoCmd.OpenReport "rptDeal Review",
acViewPreview, "qryDeals", "[Date] =" ????????
 
Try...

"[Date] Between #" & StrtDate & "# And #" & EndDate & "#"

Gary Miller
Sisters, OR
 
Back
Top