Selective Update Queries

[bl0u2011]

Happy New Year Everybody

Can Anyone help me with this please

I have a Employee Table with the following columns
EmpID
Name
Address
Telephone
PostCode
Spending

What I want to do is to update the spending column, for eg. I have the following data in spending
1233
1555
1665

I want to set the last 2 digits of the figure to '00'?
Can anybody tell me how to do this please!! I am desparate for it!

THanks
Si

 

[ColinEssex]

Is the spending figure a sum of some other calculation?

Col

 

[bl0u2011]

No

Hi There
No the spending aint from other calculation
its inputed by a person
thanks
Si

 

[Jibbadiah]

Put your table in design view.
Change the spending data type to Currency.
Change the number of decimal places to 2.