Report Footer "Missing Operator" message

[ewassmer]

Hi all,
I'm currently creating a report in Access 2003 and I get an error message when I enter a query into a text box control source.

The query is for % Yield based on two number fields in a table, and is as follows:
=(Sum[YardsOff])/(Sum[YardsOn])

This would be displayed as a percent value through the format option.

I have also tried it as
=((Sum[YardsOff])/(Sum[YardsOn])


=Sum[YardsOff]/Sum[YardsOn]
=Sum([YardsOff]/[YardsOn])

any insight? thanks!

[ewassmer]

Just an update-
When I enter
=Sum([YardsOff]/[YardsOn])
I get an overflow message.

[ewassmer]

Well, I think I found my own solution:
Sum(nz([YardsOff],0))/Sum(nz([YardsOn],0))