division by zero. whats happening?

[Guest]

I have a summary query based on a detailed query and I want to do the above.
I have a column for calculating the total amount charged for overtime and
the overall total (contracted hours plus overtime).

I want to calculate the percentage spent on overtime charges of the overall
total.

when I put this into the query

overtpct: ([overtime]*100)

it works fine but when I try to divide this by the overall total it says
"division by zero" when it clearly isn't!!!

So whats happening.

cheers

 

[Guest]

I've managed to do it in the report, but still interested in the answer!

 

[Immanuel Sibero]

Scubadiver,

It's hard to see what's happening without the query SQL text. Did you
confirm the overall total is not zero by including it in the query?
Please post the SQL.

Immanuel Sibero