All right, I use Dcount to give me a count of records matching two criteria is a query:
ContactID is a string and CallDate is a Date (full date, with hour too). Total is defined as an integer.
I get "Type Mismatch when I run this in the immediate window.
Suggestions?
Thanks
mafhobb
Code:
Total = DCount("SubcallID", "Stats Customer Subcalls", "ContactID=" & CID And "CallDate>= (Date() - 30)")
I get "Type Mismatch when I run this in the immediate window.
Suggestions?
Thanks
mafhobb