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!