Expression help

Have a query that has my units mtoe that is used for usr. now I have a column
(Sex) that when I put a soldier in the authorized spot that comes from my
units data either puts in a f for female or m for male. Is there a expression
that I can but in another column that buts a number 1 in the column if the
soldier is female or a number 0 in the column if the soldier is a Male.

Any help with this.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1

your post was a bit confusing, but if i understood correctly: you have a
query which includes a field (Sex) that contains either an "f" or an "m",
for each record. you want to create a calculated field in the query to
display a value of 0 or 1 based on the value in the Sex field.

if the above is correct, use the following expression for your calculated
field, as

GenderNum: Abs([Sex]="f")

hth


"bohon79 via AccessMonster.com" u35329@uwe wrote in message
news:7536ca200c4a2@uwe...
Have a query that has my units mtoe that is used for usr. now I have a
column
(Sex) that when I put a soldier in the authorized spot that comes from my
units data either puts in a f for female or m for male. Is there a
expression
that I can but in another column that buts a number 1 in the column if the
soldier is female or a number 0 in the column if the soldier is a Male.

Any help with this.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1