Overflow

[Joe8915]

I have been trying to solve this problem for a few days now. Here is the bottom line I just cannot figure out how to do it. I know where the problem lay and I know why it’s happing. I have found a few fixes but for the life of me I just cannot do it.

I sure would appreciate if someone take a look at my db and give me some new eyes or even help me correct it.

Thanks for taking the time to look at it.

Running ms access 2010



Joe

[Missinglinq]

...I know where the problem lay and I know why it’s happing. I have found a few fixes but for the life of me I just cannot do it.

Then perhaps you could give us a bit of a hint! You post an app with two dozen or more Objects and don't bother to tell what's actually going on, other than the single word 'Overflow?' How can we reproduce the problem? Which Object? What actions?

We'd like to help, that's why we're here, but we're not mind readers!

Linq ;0)>

[Joe8915]

Missingling, thanks for the quick reply. You are ever so corrext, I did not give you the object I was having trouble with. Please take a look at "QryWorkProduction Summary".

The Fields are as follows:
Summary detail: Sum(Fix(100*[dqty]*([dstdhc]*[drate]/[dacthc]-[drate]))/100)
Summary Partial: Sum(Fix(100*[pqty]*([pstdhc]*[prate]/[pacthc]-[prate]))/100)
Summary WV: Sum(Fix(100*[WVqty]*([WVstdhc]*[WVrate]/[WVacthc]-[WVrate]))/100)

What I think is going is the last part of the code: ))/100)


In the FrmWorkProduction subform, if numbers greater than 0 it appears that it works OK.

I had to pull this information from an excel and this what he had in the cell:


=IFERROR(TRUNC(D1005*(F1005*G1005/E1005-G1005),2),0)


D1005 G1005 E1005 G1005
6 .89 6 .89


If need more information please, please ask


Once again, thanks for taking the time to look at this


Joe

[Missinglinq]

You have two Expressions or calculated Fields (Summary Detail and SummaryPartial) in the Query, and they include division by the Fields named dacthc and pacthc, and in some cases these Fields are Zero, and division by Zero is illegal. If this expression had been in VBA code, instead of inside of a Query, the Error Message would have stated this, and it would have been easier to troubleshoot!

Linq ;0)>

[Joe8915]

Missingling, thanks ever so much for taking the time to review and chime into my problem. Not being good in VBA at all, I had to retort to using a query. With that being said, what would you think is the best way solve the problem.