problem in a form from crosstab query

M

morgan

Hi,
I have a form from a crosstab query. On that form, I've added some fields to
make "on the fly" calculations but they remain blank if one of the values
returned from the query and used for calculation is = 0.
What I can do?

Thks in advance
 
M

morgan

Thanks Allen, for the link to your web site too.

Allen Browne said:
Use Nz() around each field, to replace null with zero.

For example, instead of:
=[A] + + [C]
use:
=Nz([A],0) + Nz(,0) + Nz([C],0)

Here's another suggestion for getting a row total in a crosstab:
http://allenbrowne.com/ser-67.html#RowTotal

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

morgan said:
Hi,
I have a form from a crosstab query. On that form, I've added some fields
to
make "on the fly" calculations but they remain blank if one of the values
returned from the query and used for calculation is = 0.
What I can do?

Thks in advance
Click to expand...
Click to expand...
 
Top