You could use this --
My Stuff: IIf([b] Is Null,0,[b])

But it will prompt for [b] if it does not exist.

--
Build a little, test a little.


"tighe" wrote:

i have a form based on a crosstab query that sums on threee possible types
A, B or C. on the form the field for B shows #Name?, if B does not exist.
this is ok but i need it to show 0, any suggestions?

i tried playng with the query, but no luck there by adding a Type table.