Numbers to percentages

[ptrifile]

I have a table that holds scores based on 1,2 or 3. What I need to do is have those stored numbers converted over to a percentage by dividing the scores by 3. Is there a way to create a query to do this automatically? Any help is appreciated.

Thanks

Paul

 

[PHV]

Something like this ?
UPDATE yourTableName SET yourScoreField=yourScoreField/3
WHERE yourScoreField Between 1 And 3
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ptrifile]

Im not sure if im doing something wrong with this but when i try this all i get is the list of values for that field, it does not convert it. Is there something else i could try?

Thanks for your help!

Paul

 

[ptrifile]

Never mind. I got this to work! thank you PHV!!!!!!!!!!

 

[PHV]

Click the ! button

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244