Divide Currency Number

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am fairly new to Access and have a table with over 25ok records. I am
trying to reduce, the sales number, which field is formatted as a currency,
by 1000.

I am not quite sure where to enter the replace expression and the exact
language as I am used to using Foxpro
 
I am fairly new to Access and have a table with over 25ok records. I am
trying to reduce, the sales number, which field is formatted as a currency,
by 1000.

I am not quite sure where to enter the replace expression and the exact
language as I am used to using Foxpro
Click to expand...

If you want to permanently replace the value (i.e. a record containing
$8,215.50 becomes $8.2155, note that Currency values have four decimals)
create a Query based on the table; change it to an Update query using the
Query menu option; and on the UpdateTo line under [Sales Number] type

[Sales Number] / 1000.

If you want to keep the actual value stored but just display or use the
division result, just create the default Select Query and put the same
expression in a vacant Field cell. This Query can be used as the basis of a
report, a form (where this field will *not* be editable), an export, etc.
 
Back
Top