Pedro Janssen
pedro at plex.nl
Mon Apr 7 10:29:34 CDT 2003
Hello Group, i have a tableA with 5 fields (field size: single, decimal places:1) Not all fields have values. I want the difference from al those field, so i added a field diff. I made an update query with the following sql: UPDATE TableA SET TableA.[diff] = 100-Nz([field1],0)-Nz([[field2],0)- etc. etc.; The result that i get in field diff gives many records with more then 1 decimal places. 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 or a record that contains values like 20,5 and 20,5 i get as result 59,997854. Some result do have only one decimal place. How is this possible? TIA Pedro Janssen -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030407/6d08aab4/attachment.html>