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



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/
.



Relevant Pages

  • Re: For Marshall Barton
    ... Control Source: IncType ... Second Subreport: ... As they appear in the Detail Section of the Main Report: ... function in the report footer will work ok, ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... However, when I ran the report, it kept ... After fixing the IIf problem, ... Control Source: ABegBal ... "The LEVEL clause includes a reserved word or argument that is misspelled or ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... additional subreports into the same detail section of the main report. ... Control Source: ABegBal ... named the subreport control to make it look like a text box ... "The LEVEL clause includes a reserved word or argument that is misspelled or ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... Copy/Paste) did you put int their control source property? ... many records the main report's record source query returns ... function in the report footer will work ok, ... the subreport CONTROL on the main report. ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... the ending balance. ... a Main Report: rpt_AFinancialStmt. ... 2nd Field is first SubReport: ... as the Control Source in an unbound text box. ...
    (microsoft.public.access.reports)