how to locate currency records with too many decimal places?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

only example some records have $231.035, which shows when you click in it.
how can i fiilter these out to correct them?
 
only example some records have $231.035, which shows when you click in it.
how can i fiilter these out to correct them?
Click to expand...

Sneaky way to do this: use a criterion on the field of
100. * CCur([fieldname] / 100)
Click to expand...

Dividing by 100 will truncate the last two digits after the decimal
(since a Currency is limited to 4 decimals); this will compare the
231.035 in the field to 231.03. Only those values with an extra digit
or two will meet the criterion.

If you'ld just like to get rid of all the fractions without
investigating them, just run an Update query to this same expression.

John W. Vinson[MVP]
 
Back
Top