Need help with complicated if statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Group,
Would appreciate if someone could help me with a complicated if
statement.
Here the set up...(I manage as awards database for applicants)
Applicants must select at least 1 target and can have up to 7 targets
(each target is a separate record)
Particular emphasis is placed on two of those targets, i.e. Female and
<25 years of age.
Therefore if Female is not selected then it means that the applicant is
a male and if <25 is not selected then it means that the person is >25
years of age.
Therefore, I am trying to code the logic to show either one of the
following 4 situations which could arise...

1 Female <25
2 Female >25
3 Male <25
4 Male >25

Here's some sample code...obviously I am missing some clever code to
make the age work correctly if you know what I mean.

KeyTarget:
IIf([TargetGroupName]="Female","Female",IIf([TargetGroupName]<>"Female","Male"))

Could someone help me?

Thanks
Tony

.

Relevant Pages

  • Re: Need help with complicated if statement
    ... >Applicants must select at least 1 target and can have up to 7 targets ... ><25 years of age. ... >Therefore if Female is not selected then it means that the applicant is ... >a male and if 25 ...
    (microsoft.public.access.queries)
  • Re: InuYasha: The chick with the folding sword isnt...?
    ... Japanese that Jakotsu is a guy despite the fact his Japanese voice actor ... turned one of Queen Beryl's Male generals into a female because they ... with another on a show that they had decided to target towards the ... pre-puebescent age catagory, despite that it originally was targeted ...
    (rec.arts.anime.misc)
  • Re: Things we remember...
    ... Which was the target of desire, ... the female or the underwear? ... And/or that partial disrobing is less practical with pantyhose. ...
    (rec.arts.sf.written)
  • Re: Things we remember...
    ... Which was the target of desire, ... the female or the underwear? ... And/or that partial disrobing is less practical with pantyhose. ...
    (rec.arts.sf.written)
  • Re: (ndc)opinions wanted
    ... Unless say 80% of the applicants are one gender and 20% are another. ... available for males and females. ... Once the male slots were filled, ... Was it an assumption that the pool of applicants ...
    (rec.music.gdead)