Divide Currency Number

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.
 
A

Arvin Meyer MVP

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.
 
Top