DaniBoy
Registered User.
- Local time
- Today, 14:24
- Joined
- Nov 18, 2001
- Messages
- 174
Hello,
I want to be able to count all the workorders that have the "NewCheckBox" to true. I also made an expression called days that gives me the datedif between DateRec and DateCompleted. I want that to be greater than 7
Thanks
here is the code that I have and it gives me a "-1" answer.
=DCount("[NewCheckBox]","qryTotalWOProcessed","[NewCheckBox]= -1") And ("[Days]","qryTotalWOProcessed","[Days]>7")
I want to be able to count all the workorders that have the "NewCheckBox" to true. I also made an expression called days that gives me the datedif between DateRec and DateCompleted. I want that to be greater than 7
Thanks
here is the code that I have and it gives me a "-1" answer.
=DCount("[NewCheckBox]","qryTotalWOProcessed","[NewCheckBox]= -1") And ("[Days]","qryTotalWOProcessed","[Days]>7")