Sql in Vb or Access!

i wont too chenge a field value.when the field value is 1 it be "man" and if it is 2 "woman"?

and any more works like this:
select field1,count(case [filed2] when 1 end)*8+count(case [filed2] when 2 end)*4 +count(case [filed2] when 3 end)*2 from table group by field1,field2
:o
thanks a lot :WAVE: