>>
>>My data tables is has a reference total field set up as Numeric(10,2). I need to calculate some child records (child.qty * child.price * child.markup), then compare that to a ref number stored in the parent header (I know, a bad practice, and I'm getting away from it soon).
>>
>>So the SQL select is returning a sum like 254.0321 and even when I use Cast on the result, it will not test out as equal to 254.03.
>>
>>llAuditPassed=Cast(csrAudit.nTestTotal as Numeric(10,2))=Parent.RefTotal will return .F.
>
>The ROUND() maybe better choice in this case but you'll have to test that
>
>llAuditPassed=ROUND(csrAudit.nTestTotal,2))=Parent.RefTotal will return .F.

Indeed, Round gave the expected results.