DCount and NZ

[DS]

I tried both of these expressions to get a 0 when there are no
records...neither works. Any suggestions?

=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

Thanks
DS

 

[Klatuu]

I'm not sure what you are trying to do. They way your code is structured,
the only time you will get 0 is when there are no records in the table at
all. You don't have criteria defined.

 

[Marshall Barton]

I tried both of these expressions to get a 0 when there are no
records...neither works. Any suggestions?

=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

There must be something else going on. I always get a zero
when there are no records. Whatever it is, I can't see it
in your posted expression.

Note that the Nz is unnecessary with DCount.

 

[Jörg Ackermann]

Hi,

DS schreibselte:

I tried both of these expressions to get a 0 when there are no
records...neither works. Any suggestions?

=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

Thanks
DS

Try:

=DCount("*","UnPaidChxQ")

or

DCount("SalesID","UnPaidChxQ")


Acki

 

[DS]

I'm not sure what you are trying to do. They way your code is structured,
the only time you will get 0 is when there are no records in the table at
all. You don't have criteria defined.

:

I tried both of these expressions to get a 0 when there are no
records...neither works. Any suggestions?

=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

Thanks
DS

Thats it, Whenever I don't hae any records I want a Zero.
Thanx
DS

 

[DS]

I tried both of these expressions to get a 0 when there are no
records...neither works. Any suggestions?

=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

There must be something else going on. I always get a zero
when there are no records. Whatever it is, I can't see it
in your posted expression.

Note that the Nz is unnecessary with DCount.

Thanks, I changed my Query around and that worked. It was an incorrect
join.
Once again everyone, Thank You!
DS

 

[DS]

Hi,
DS schreibselte:

I tried both of these expressions to get a 0 when there are no
records...neither works. Any suggestions?

=NZ(DCount([SalesID],"UnPaidChxQ"),0)
Text10=NZ(DCount([SalesID],"UnPaidChxQ"),0)

Thanks
DS

Try:

=DCount("*","UnPaidChxQ")

or

DCount("SalesID","UnPaidChxQ")


Acki

Thanks, see previous post.
DS