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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
How do I get Access to append the exact amount with decimals? 2
Too many numbers past the decimal 5
Too many decimal places in Pie Chart 1
Decimal Place problem 2
Currency Decimals 5
Decimal Field's Precision Too Small to accept the numeric you ... 3
dropdown decimal places 4

Back
Top