*Headdesk*
Tell me, oh Oracle of Access, why is 0.0021 not equal to 2.1/1000? When asked for the difference between them, why do you say that it is -4.33680868994202E-19? How does this number survive conversion to a single? Or, for that matter, a restriction to 10 decimal places? (See that? 10 dp. Not 19!)
I've tried other conversions. I've tried manually entering the source values (that cleared the other like this!). There is one other set of conversions to try, else I'll just exclude that product from this query.
***EDIT***EDIT***EDIT***EDIT***
The expression CSng(Value1-Value2) produced the above 19-dp nightmare. The expression CSng(CSng(Value1)-CSng(Value2)), OTOH, produces acceptable results. So does dropping the initial "CSng" function. Weird.
I've tried other conversions. I've tried manually entering the source values (that cleared the other like this!). There is one other set of conversions to try, else I'll just exclude that product from this query.
***EDIT***EDIT***EDIT***EDIT***
The expression CSng(Value1-Value2) produced the above 19-dp nightmare. The expression CSng(CSng(Value1)-CSng(Value2)), OTOH, produces acceptable results. So does dropping the initial "CSng" function. Weird.