S
Shannon
Gina,
Your query asks for any employees with an absence between
X and Y or any employees with no absence (null value) at
all. If you are specifying a null value for the
eventDate, but still want to restrict by some other date
parameter, say a report month for instance, you need to
include that parameter.
Something like:
DoCmd.OpenReport "rptBonusEligibilityDetail",
acPreview, "",
("([EventDate]Between Forms![frmPrintReports]!
[txtBegDate] and Forms![frmPrintReports]!
[txtEndDate]) or ([EventDate] is Null and ReportDate
Between Forms![frmPrintReports]![txtBegDate] and Forms!
[frmPrintReports]![txtEndDate]) ")
In any case, if the null value in event date is giving
you results beyond your desired parameters, you need to
restrict the results by another field.
Hope this helps.
-sg
Your query asks for any employees with an absence between
X and Y or any employees with no absence (null value) at
all. If you are specifying a null value for the
eventDate, but still want to restrict by some other date
parameter, say a report month for instance, you need to
include that parameter.
Something like:
DoCmd.OpenReport "rptBonusEligibilityDetail",
acPreview, "",
("([EventDate]Between Forms![frmPrintReports]!
[txtBegDate] and Forms![frmPrintReports]!
[txtEndDate]) or ([EventDate] is Null and ReportDate
Between Forms![frmPrintReports]![txtBegDate] and Forms!
[frmPrintReports]![txtEndDate]) ")
In any case, if the null value in event date is giving
you results beyond your desired parameters, you need to
restrict the results by another field.
Hope this helps.
-sg