I have a table that holds scores, they are either scored a 1, 2, or 3. I am trying to convert all of those to a percentage by dividing them by 3. I created the following query but i get an error unless I change the tables properties for those fields from a fixed number to "Text", but that skews or changes the data:
UPDATE monitoring SET CS_Score=CS_Score/3
WHERE CS_Score Between "1" And "3"
;
Is there a different way i can get this accomplished without jeopardizing my data??
Any help is appreciated.
Thanks!
Paul
UPDATE monitoring SET CS_Score=CS_Score/3
WHERE CS_Score Between "1" And "3"
;
Is there a different way i can get this accomplished without jeopardizing my data??
Any help is appreciated.
Thanks!
Paul