I'm a user in a db I built. I have approx 3000 customers in my bd...some new some a few yes old. I assign a unique status to them such as paid, hot, follow up, ect....I have a button with code to open my "hot" status customers. Nest to the button I have a text box and I want to display the number of hot status accounts so I could see them at a glance. I tried using d count but get an error in form view....any idea what I'm doing wrong....tried at least 20 to fix..

---

Reply from Alex Hedley:

Can you show me your DCOUNT code.

DCOUNT and other Aggregate Functions are covered in Expert 29.