Divide Currency Number

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

Jeff

I am fairly new to Access as I have just moved my table from Foxpro to Access.

I have a table that has over 250k records with a number of TEXT, NUMBER and
one CURRENCY field. I am trying to reduce divide the currencty number by
1000 but I am not quite sure where I am to write the replace expression for
this one time conversion.

As I said I am new to Access and would appreciate any assistance.
 
Create a query and run it against the currency field in the table. If it's a
one time event, delete the query when you've done what you wish.
 
Back
Top