Dcount Again

[Little Penny]

How do I add the value of these two dcount statements into one textbox. And if no records than display a zero



=Nz(DCount("OperatingSystem","CountW2KPBCC"),0)

=Nz(DCount("OperatingSystem","CountW2KPB200"),0)


Thank you

 

[Tom Lake]

How do I add the value of these two dcount statements into one textbox.
And if no records than display a zero



=Nz(DCount("OperatingSystem","CountW2KPBCC"),0)

=Nz(DCount("OperatingSystem","CountW2KPB200"),0)

=Nz(DCount("OperatingSystem","CountW2KPBCC")+DCount("OperatingSystem","CountW2KPB200"),0)


Tom Lake

 

[John Vinson]

How do I add the value of these two dcount statements into one textbox. And if no records than display a zero



=Nz(DCount("OperatingSystem","CountW2KPBCC"),0)

=Nz(DCount("OperatingSystem","CountW2KPB200"),0)

Just add them:

=Nz(DCount("OperatingSystem","CountW2KPBCC"),0) +
Nz(DCount("OperatingSystem","CountW2KPB200"),0)

You do need to do the NZ() first and add the NZ() calls; otherwise if
one DCount is null, the whole expression will be NULL and you'll lose
the other real value.

John W. Vinson[MVP]