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