selcting report criteria

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] =" ????????
 
G

Gary Miller

Try...

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

Gary Miller
Sisters, OR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report based on field criteria 2
Reports filtering 1
Open report with limited date-range as tought by A.Browne 2
report date range 3
Use combo to print report between two sets of dates 1
Open Report with the parameter 1
Form to open report based on several combo boxes 4
Add password to an exported report 0

Top