New access user needs help!

[cmcnulty]

I am trying to get my report to accurately retrieve values from queries. The queries basically are designed to count the fields needed from a prospects table.

The problem is when the query counts 0 fields, a 0 is not entered in the query therefore the textbox on my report is blank and I cant perform calculations.

Is there anyway to get a zero to appear either in the query or in the reports textbox???

 

[mdemarte]

I will take a stab at this. If your field is boolean and was called contactme, then something like

= IIf([contactme],1,0)

Should work. Basically, if [contactme] is True or Yes, then you want a one, otherwise it is a zero.

Then, you do a Sum of that field.

 

[Rich]

Nz([YourField],0) .