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.
 
Top