Reply to thread

Message: [QUOTE="Craig Alexander Morrison, post: 2561023"] Ian you can apply the format statement in an update query to ensure all records are correctly formatted/recorded before running reports, or if you do not want to touch the records you can use the format statement in the query you are running to get the totals. Indeed you could skip updating the value on entry if that was not important and just do the bulk update in a query prior to using the data for reporting and other purposes. Perhaps do both for a belts and braces approach. As most of our systems have been multi-currency we have used the Currency field as many of our values are the result of a currency exchange rate but you are right the rounding can bite you if you aren't careful. It can look quite wonderful to see a computer produce a report showing thousands of lines with zero pence and a total of 2,345,345.04. [/QUOTE]