Hayley Baxter
Registered User.
- Local time
- Today, 16:39
- Joined
- Dec 11, 2001
- Messages
- 1,607
I am using the DCount function to count the values of my category's field. I have used this many times before and I can't see any problems with my syntax but yet I keep getting #error returned I'm puzzled can anyone see what I can't?
=DCount("[CategoryID]","tblProspects","[CategoryID] = 'Newscorp'")
Many thanks
Hay
=DCount("[CategoryID]","tblProspects","[CategoryID] = 'Newscorp'")
Many thanks
Hay