View Full Version : Two dcount on the same field!!


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")

Pat Hartman
10-19-2002, 05:03 PM
I'm not 100% sure that I understand your question. I'm assuming that you want a count of the work orders with NewCheckBox = True and #Days between DateRec and DateCompleted > 7.

=DCount("[NewCheckBox]","qryTotalWOProcessed","[NewCheckBox]= -1 AND [Days]>7")