Help!!

[oklahoma84]

I have monthly data in a crosstab query. In some months there is no activity for accounts. I would like there to be a zero in these blanks. I think i need to use the NZ function but I do not know how. Can someone help me!!

 

[CraigDolphin]

In the design view of your crosstab query you have a data field that is somehow grouped as a 'value' in your crosstab query. Replace the field name with something analogous to:

MyNewFieldName: Nz(Avg(TableNameHere.DataFieldNameHere),0)

And use 'Expression' in the total row for that field.

Substitute Sum, Max, Min, or whatever for Avg as appropriate

 

[oklahoma84]

When i tried that it states "the text i entered is not in the list" Can you help?

 

[CraigDolphin]

can you post a compacted, zipped version of your db? (remove any sensitive data etc first)