Using dcount...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
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
 
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
Access Dcount (multiple criteria) 3
DCount alwaysreturning 1 0
DCount in Subform question 1
dcount won't work? 1
Dcount return incorrect result for filtered record 4
Access MS Access DCount function problem 0
Dcount Problem 6

Back
Top