Calculation confusion

[Sully38]

I am working with a table that breaks data into percentage values to 15th decimal place. I am presently writing a query that needs to show which one of the records don't total 100%. I am using a criteria statement of <>1 to drop everything that is not 100%. Presently, I still get records appearing that are 100%. What is the best and most accurate way to sum values? I am using just the "sum" on total line is their a better way.

 

[Norie]

I still get records appearing that are 100%

Are you sure they are exactly 100%?

Could it not be that they are +/- a very small amount?

If so you may want to set some sort of margin for your query.

eg Between 0.99999 And 1.00001.

 

[Sully38]

That did the trick... Curious Access shows the records as 100.0(15) How do I find out exactly where the error is? When Access doesn't go beyond 15 decimal places?