Hello,
I have added up all payments in a table and get a sum that end in 3 decimals.
Obviously there must be a typo in there somewhere.
Initially I have formatted the currency field in the table to show 3 decimal places. My intention then was to use the Right function to select the 3rd decimal digit and then find anything that wasn’t a zero.
The problem is that Access ignores the third decimal, so it returns a number on all results.
Is there any code that has been written or has anyone a solution to find typo errors in currency fields?
So in essence there must be one or more records that have a value at the 3rd decimal place - i.e. £50.238
It's a large table (200000+ records) so doing it manually would be a long job.
Many thanks Mark
I have added up all payments in a table and get a sum that end in 3 decimals.
Obviously there must be a typo in there somewhere.
Initially I have formatted the currency field in the table to show 3 decimal places. My intention then was to use the Right function to select the 3rd decimal digit and then find anything that wasn’t a zero.
The problem is that Access ignores the third decimal, so it returns a number on all results.
Is there any code that has been written or has anyone a solution to find typo errors in currency fields?
So in essence there must be one or more records that have a value at the 3rd decimal place - i.e. £50.238
It's a large table (200000+ records) so doing it manually would be a long job.
Many thanks Mark