Prev: adding another control
Next: Suppress printing group footer using Calculated field(s)
From: TheDrescher on 17 May 2010 13:23
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!
From: Marshall Barton on 17 May 2010 13:57
TheDrescher wrote:

>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.

--
Marsh
MVP [MS Access]
From: TheDrescher on 18 May 2010 09:58
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" wrote:

> TheDrescher wrote:
>
> >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.
>
> --
> Marsh
> MVP [MS Access]
> .
>
 | 
Pages: 1
Prev: adding another control
Next: Suppress printing group footer using Calculated field(s)