<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello Group,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>i have a tableA with 5 fields (field size: single,
decimal places:1)</FONT></DIV>
<DIV><FONT face=Arial size=2>Not all fields have values.</FONT></DIV>
<DIV><FONT face=Arial size=2>I want the difference from al those field, so i
added a field diff.</FONT></DIV>
<DIV><FONT face=Arial size=2>I made an update query with the following
sql:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>UPDATE TableA SET TableA.[diff] =
100-Nz([field1],0)-Nz([[field2],0)- etc. etc.;<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>The result that i get in field diff gives many
records with more then 1 decimal places.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>For example: When i have a record which contains
values like 5,1 and 94,9 (all values are typed in this way and are not
calculated) i get as result 0,11176548</FONT></DIV>
<DIV><FONT face=Arial size=2>or a record that contains values like 20,5 and 20,5
i get as result 59,997854.</FONT></DIV>
<DIV><FONT face=Arial size=2>Some result do have only one decimal
place.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>How is this possible? </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro Janssen</FONT></DIV></BODY></HTML>