Adding control to report

T

TheDrescher

I'm currently running a retention report from my database where you select a
specific date range and it returns all records from that range. The code I
use is:

Dim strWhere As String
Dim stDocName As String
stDocName = "RetentionReport"
strWhere = "[Date] >= #" & _
Forms!CountsReportMenu![FromDate] & "# And [Date] <=#" & _
Forms!CountsReportMenu![ToDate] & "# "

DoCmd.OpenReport stDocName, acPreview, , strWhere

I'd like to add a line in so it will also pull only the records where the
RetentionEffort field = Yes. Is there any way I can add this to my current
code? Thanks!
 
T

TheDrescher

My apologies, the question was never showing up so after a couple of hours I
figured I hit the wrong button and re-sent it. Thanks for the help!

Marshall Barton said:
TheDrescher said:
I'm currently running a retention report from my database where you select a
specific date range and it returns all records from that range. The code I
use is:

Dim strWhere As String
Dim stDocName As String
stDocName = "RetentionReport"
strWhere = "[Date] >= #" & _
Forms!CountsReportMenu![FromDate] & "# And [Date] <=#" & _
Forms!CountsReportMenu![ToDate] & "# "

DoCmd.OpenReport stDocName, acPreview, , strWhere

I'd like to add a line in so it will also pull only the records where the
RetentionEffort field = Yes. Is there any way I can add this to my current
code?


I tried to answer this question in another newsgroup.
Please do not post the same question multiple times. If you
feel you must post a question to multiple groups, which is
very rarely useful, cross post it by putting both groups in
the To field of a single post.
 

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

Top