DaniBoy
10-15-2002, 10:22 AM
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")