net & .mdb, count() & nz()

  • Thread starter Thread starter RicercatoreSbadato
  • Start date Start date
R

RicercatoreSbadato

hi all, i'm using a file .mdb as a database for my little software.
the problem is on a query with a count(*) statement.
if I use ms access, then i can use the nz(.., 0) in a query with the
count() statement.

but if I use the .mdb file from .net, then i can't use the nz()
construct.. how i can have a 0 (zero) if the the count() doesn't
return results ?
 
Try IIf().

Without testing, I suspect JET will be able to handle that natively, e.g.:
IIf([SomeField] Is Null, 0, [SomeField])
 
Back
Top