DCount Question

[stew561]

I have a report based on a query. My DCount syntax works if I don't put a criteria prompt in my query. Why is that?


Can you use DCount in a query that requires a criteria prompt?


Thanks for you help

 

[gemma-the-husky]

yes, count items where some condition applies

so if it's not working, your syntax is probably incorrect - can you post it?