How do you filter two calculated text boxes in a report?
- Thread starter wwhit
- Start date
I have tried a couple of options like putting a message box in report page or report print to let the user know if there is a blank page that they have no employees. Still not sure if there is an option. Thanks for helping me with all of this. Let me know if you find a way around it...
- Local time
- Today, 14:48
- Joined
- Aug 30, 2003
- Messages
- 36,272
Can an employee have more than one record? If not, this seems to work:
strFilter = "(Nz([7],0)+Nz([8],0)+Nz([9],0)+Nz([10],0)+Nz([11],0)+Nz([12],0))-24 > 0"
stDocName = "2011 Sick AbuserTbl MM Report"
DoCmd.OpenReport stDocName, acPreview, , strFilter
You can't have the Sum() function in the wherecondition, so this looks at each individual record. In my brief tests, this triggers the no data event, and as expected the second message from the error handler.
strFilter = "(Nz([7],0)+Nz([8],0)+Nz([9],0)+Nz([10],0)+Nz([11],0)+Nz([12],0))-24 > 0"
stDocName = "2011 Sick AbuserTbl MM Report"
DoCmd.OpenReport stDocName, acPreview, , strFilter
You can't have the Sum() function in the wherecondition, so this looks at each individual record. In my brief tests, this triggers the no data event, and as expected the second message from the error handler.
Worked like a charm. I did try to do the strFilter with the "calculation" however I was keeping the "Sum" still in the coded information. No wonder it wouldn't work. Thanks again for all your help. The report is now completed thanks to you and your great expertise!!!
