Trailing zeros

[mccallen60]

Hello,
I have a table that has a utilization qty field. The utilization qty has
three trailing zeros that are not needed. Below is what it currently looks
like and what I need it to look like:
Current: Need:
Utilization Qty Utilization Qty
60000 60
-15000 -15
120000 120
-240000 -240

Can you help me with a solution? Thanks, Kevin

 

[KARL DEWEY]

Divide by 1000

 

[fredg]

Hello,
I have a table that has a utilization qty field. The utilization qty has
three trailing zeros that are not needed. Below is what it currently looks
like and what I need it to look like:
Current: Need:
Utilization Qty Utilization Qty
60000 60
-15000 -15
120000 120
-240000 -240

Can you help me with a solution? Thanks, Kevin

Do you wish to permanently change the data?
Back up your table first.
Then run an update query. Here is the SQL needed. Just change the
table and field names to your actual names:

Update YourTable Set YourTable.[UtilizationQty] =
[UtilizationQty]/1000;