Expression help

[bohon79 via AccessMonster.com]

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.

 

[tina]

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