Re: =Iff(([Me]![Gender])="M","Male","Female")

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote

>> ;"Male";"Female"
>> assuming Male is the checked value.
>
> Why not checked = Female?

If I understood correctly, he was explaining why he used the particular
format. If so, the answer to your question would be: Because that Format
doesn't work if "checked = Female"; it would be ;"Female";"Male".

> I would never represent something that is neutral by using a
> Boolean.

What's neutral in this case?

> Second, in cases where the value is unknown, there is no way to
> store that using a Boolean field.

Unknown, I can understand; neutral, I can't, without explanation.

Larry


.

Relevant Pages

  • Re: Advice for mid-life career change (to programming)
    ... when applying for programming - it's a hardware/OS ... Most tech positions I see require an A+ as a minimum - I've even seen tech ... > I'd try to post in some format other than as a Woid document, ... > unknown individual on an unknown site...didn't until after someone else ...
    (comp.programming)
  • Re: Adding Fields in Table with VBA
    ... you can modify the format property of your ... Dim dbs As Database, tdf As TableDef, fld As Field ... > problem starts with I try to add a Boolean field. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Standards question on edited fields
    ... I did not state that it was bad design, ... I simply said that I didn't see it's use, explaining why, ... and explicitly allowed that there might be a good reason. ... Dates in that format would ...
    (comp.lang.cobol)
  • Re: large scale applications
    ... got a file called:- arkdhnYZb which claimed it was an unknown ... most Postscript viewers can deal with gzipped ... "unknown format). ... M. Anton Ertl http://www.complang.tuwien.ac.at/anton/home.html ...
    (comp.lang.forth)
  • Re: Date Format Changes Back
    ... when I set my Regional and Language Options to Long Date Format (dddd, ... display long date instead of short date? ... "Unknown" wrote: ...
    (microsoft.public.windowsxp.general)