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.
 

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

Divide Currency Number 1
Where and how can I adjust a curreny number 1
Copy previous record into form field 0
Change Currency 1
"Compile error in table level validation expression " after format 0
Unique values divide by zero error 1
DLookup Function 2
Number Format 2

Top