Invalid use of Null in Report footer 1

[hefly]

I have created a report footer where I want to sum a field.

I have used the following:

=Sum(Nz([Net],0)) 

And =Sum([Net])

Both return an error "Invalid use of null."

How do I sum a field with nulls in my footer?

Thank you.

Hefly

 

[dhookom]

There shouldn't be an issue if these are control sources of text boxes in the Report Footer (or Report Header or Group Header/Footer).

Are you trying to do something in code?
Does the report return records?

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

I don't know what the problem was... There was no code. I kept getting an error "Invalid Use of Null."

Was it my formula, or something may have been wrong with the footer?

I deleted the footer and then re-created the footer with the following code which ran.

=(Nz(Sum([Net]),0))

Whatever the issue was, whether the footer, or the code I was using, the report is running now.

Thank you Duane!

Hefly

 

[dhookom]

I'm not sure how you could determine the error message was being caused by the control and not something else.

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

As before, I am clueless.

Thank you for your help.

 

[dhookom]

hefly,
You had stated originally [blue]Both return an error "Invalid use of null."[/blue]
I'm not sure how you determined this expression/control was causing the issue.


Duane
Hook'D on Access
MS Access MVP