Trailing zeros

  • Thread starter Thread starter mccallen60
  • Start date Start date
M

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
 
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
Click to expand...

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;
 
Back
Top