Re: =Iff(([Me]![Gender])="M","Male","Female")
- From: "David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx>
- Date: Fri, 30 Dec 2005 21:48:54 -0600
fredg <fgutkind@xxxxxxxxxxxxxxx> wrote in
news:1cads9gkp0bfl.x4e6c7g29elf$.dlg@xxxxxxxxxx:
> 2) Why a field that stores "M" or "F"? Why not just simply store
> "Male" or "Female"? Or since there are only the 2 choices, why not
> a Check Box field? Then in a regular unbound text control on your
> report, set the control source to the CheckBox field and have it's
> Format property set to:
> ;"Male";"Female"
> assuming Male is the checked value.
Why not checked = Female?
I would never represent something that is neutral by using a
Boolean.
Second, in cases where the value is unknown, there is no way to
store that using a Boolean field.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.
- Follow-Ups:
- Re: =Iff(([Me]![Gender])="M","Male","Female")
- From: Larry Linson
- Re: =Iff(([Me]![Gender])="M","Male","Female")
- References:
- =Iff(([Me]![Gender])="M","Male","Female")
- From: campbellbrian2001
- Re: =Iff(([Me]![Gender])="M","Male","Female")
- From: fredg
- =Iff(([Me]![Gender])="M","Male","Female")
- Prev by Date: Re: Year Numbers
- Next by Date: Re: =Iff(([Me]![Gender])="M","Male","Female")
- Previous by thread: Re: =Iff(([Me]![Gender])="M","Male","Female")
- Next by thread: Re: =Iff(([Me]![Gender])="M","Male","Female")
- Index(es):
Relevant Pages
|