T
TheDrescher
I'm currently running reports from my database for a date range using
controls FromDate and ToDate. This works fine, but I'd like the reports to
also sort by an additional control called EmpSelect. The current code I'm
using is:
Dim strWhere As String
Dim stDocName As String
stDocName = "FreqByEmployee"
strWhere = "[Date] >= #" & _
Forms!FreqReportMenu![FromDate] & "# And [Date] <=#" & _
Forms!FreqReportMenu![ToDate] & "# "
DoCmd.OpenReport stDocName, acPreview, , strWhere
How could I incorporate this new control without buggering up the code I
already have? Thanks!
controls FromDate and ToDate. This works fine, but I'd like the reports to
also sort by an additional control called EmpSelect. The current code I'm
using is:
Dim strWhere As String
Dim stDocName As String
stDocName = "FreqByEmployee"
strWhere = "[Date] >= #" & _
Forms!FreqReportMenu![FromDate] & "# And [Date] <=#" & _
Forms!FreqReportMenu![ToDate] & "# "
DoCmd.OpenReport stDocName, acPreview, , strWhere
How could I incorporate this new control without buggering up the code I
already have? Thanks!