Using dcount...

B

Brad Pears

I am using dcount on a form field to list the # of records (tasks in this
case) that a user has. When that count returns no records, the screen field
shows #error..

How can I set it so that if dcount returns nothing, it shows 0 instead??

Thanks,

Brad
 
D

Dan Artuso

Hi,
DCount itself returns 0 when there are no records, so I'm not sure what your problem is.
Are you doing this in code or do you simply have DCount(....) on the property sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount function in access 0
DCount alwaysreturning 1 0
Access Dcount (multiple criteria) 3
dcount won't work? 1
Access MS Access DCount function problem 0
Dcount type of function on a form 6
DCount in Subform question 1
How set this DCount criteria? 1

Top