decimals not entered in data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that has a column of data that was entered without decimal
places where 9850 is 98.50. I need to change the data so it has the decimal.

Is there a way to do this without using code?? just wanted to check that
possiblity first.
 
Just build an update query and divide the number by 100


Update to: [yourfieldname]/100

Of course, you have to make sure your field accepts decimals. Open your
table in design view and make sure the field is a number and verify that the
"size" is not an integer. Integers (by definition) are whole numbers.
 
Thanks Rick, That was too easy of a solution. I was obviously making it
harder than need be.

Rick B said:
Just build an update query and divide the number by 100


Update to: [yourfieldname]/100

Of course, you have to make sure your field accepts decimals. Open your
table in design view and make sure the field is a number and verify that the
"size" is not an integer. Integers (by definition) are whole numbers.

--
Rick B



Turin said:
I have a table that has a column of data that was entered without decimal
places where 9850 is 98.50. I need to change the data so it has the
decimal.

Is there a way to do this without using code?? just wanted to check that
possiblity first.
Click to expand...
Click to expand...
 
Back
Top