Update Query - getting erratic results

[SkipVought]

In a MS Access, I am running VBA. Here's the snippet that seems to be returning erratic results...

With rstPWB
...
  Do While Not .EOF
...
'Create QueryDef
    qdfPWB.SQL = "UPDATE Temp_WorkOrderEst" & _
             " SET Estimate = " & strEquation & _ 
             " WHERE Counter = " & intRecordNo & _ 
             strCondition
    Debug.Print qdfPWB.SQL
    qdfPWB.Execute
  Loop
  .Close
End With

where strEstimate is a record specific equation of numeric field elements like

(SQFTPAN*2)/(1000*MYIELDPCT*MPARTPERPAN)

It is the result of this calculation that is erratic.

???

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[markgrizzle]

Try explicitly defining the size of each variable using the cDbl() function, etc. Access sometimes internally uses too small a variable type if each half of your calculation fits within that smaller type.

32000 * 32000 generates runtime error 6 - overflow error, as well as cdbl(32000 * 32000)

cdbl(32000) * cdbl(32000) works.

In your specific case you may need to wrap each of the individual elements.

 

[SkipVought]

We finally got this solved.

Thanx to all!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com