problem in a form from crosstab query

[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

 

[Allen Browne]

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

 

[morgan]

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

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.

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