Update-Query with format string for decimal values?

  • Thread starter Thread starter Markus Wallner
  • Start date Start date
M

Markus Wallner

Hi!

My task is to convert an old MS Access database with Austrian Schilling
values into Euro. I use the following update statement:

UPDATE RateTrain SET Rate=Rate/13.7603;

This basically works fine! The problem is that, for example, the value 31 is
converted into 2,252857.... Is it possible to add a format string into the
update statement, so that only the first two decimal places are displayed?

Database: MS Access 2003

Thanks in advance,
Markus
 
If you want to format only the *display*, you can use the Format property of
the Control that displays this value to only 2 decimal places.

If you want to *store* the result in the Table as a 2-decimal place value,
you can use either the CCur() function (sounds appropriate here as you are
talking about currency) or the Round() function.

Check Access VB Help on the above functions.
 
Back
Top