Showing Zero where feild is blank OR non existant

[MoeIndustries]

Hello, so, it's a little complicated. I have a database that I'm trying to show the results from as a crosstab table. This feeds into my reports.



The problem is there are some fields which aren't blank but don't exist in the database so the NZ function doesn't work because the field isn't there at all!

I'll try to clarify. My report shows 2 headings, Unrestricted and Restricted. There are two lines I want to report under these headings, voluntary and non-voluntary income. The database, in two columns, shows this:

Unrestricted	Voluntary	100
Unrestricted	Non-Voluntary	250
Restricted	Non-Voluntary	185

So my report looks like this:

	Unrestricted	Restricted
Voluntary	100
Non-Voluntary	250	185

The problem is, when I total the columns and rows I get 0 because the fact "voluntary restricted" doesn't actually exist throws out the sum formula and the NZ function doesn't work on a non existing field.

Any suggestions would be AMAZING!!

[ranman256]

NZ([field]) as Restricted

[MoeIndustries]

Here's before NZ in the report, then the formula I'm writing then the result.