Records w no data on report?

[wnicole]

I have a report that has budget, total spent then remaining for ea project.
Then sum up the variances for all projects for the year. With me so far?
Budget - Expenses = balance
Ex: $100,000 $1000 $90,000

However if the project has no expense it leaves the variance blank and not carry over the budget which makes the report inaccurate.

Ex: $100,000 $0.00 Blank

I still need the budget to carry over if there is no expense. I have the expense as default and am forced to keep adding one records to make sure it appears. I'm sure there is an automatic way I'm missing.

Can u assist?

[rpeare]

sounds like you want the NZ function

in other words if your sum(expenses) is null (because there are no expenses) you would want something like

Budget - (nz(sum(expenses), 0)

Any mathematical function that has a null value anywhere in it is likely to show up as a null value itself, what you're doing here is forcing the sum of your expenses to be 0 if there are no expenses for that particular budget line item.

[pbaldy]

Typically you can use the Nz() function around each value to replace Null with 0.