ACCESS FEED: RE: [MS_AccessPros] Missing First Names

Jumat, 20 Februari 2015

RE: [MS_AccessPros] Missing First Names - Final

OOOPS!

Yes, now I see the error of my ways!

It is still "Under Construction' so I can fix it.

Thanks,

Robin

At 21/02/2015 10:58 AM, you wrote:

Do you have a field in your table named convenor?

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sat, 21 Feb 2015 10:19:23 +1100
Subject: RE: [MS_AccessPros] Missing First Names - Final

I have now tested this:

Gender: IIf([convenorGenderMale],[mFirstName],[fFirstName])

and I have the result that I need.

Many thanks for your advice.

Robin

============================
Thanks Again Duane,

The column [convenorGenderMale] has values. Ticked box and box only.

I have edited your test code to:

Gender: IIf([convenorGenderMale],"M","F")

and M and F appear in the appropriate record.

I then changed my code to:

Convenor: IIf([Gender]="M",[mFirstName],[fFirstName])

and still no names!

Regards,

Robin

At 21/02/2015 08:59 AM, you wrote:
>I would try some troubleshooting by simplifying and then building back up:
>
>1) try a column with just [convenorGenderMale] to make sure the
>column has values
>2) Then add some complexity to the column in the query with two items like:
> TestGender: IIf([convenorGenderMale],"M","F")
>This expression relies on only two items IIf() and the value of
>[convenorGenderMale] while the original expression relied on four
>items (adding in the two fields)
>3) add in progressively more complexity until something goes wrong
>
>That's basically how I work through problems (I have lots of
>practice). Simplify and then gradually add complexity.
>
>Duane Hookom, MVP
>MS Access
>________________________________
> > To: MS_Access_Professionals@yahoogroups.com
> > From: MS_Access_Professionals@yahoogroups.com
> > Date: Sat, 21 Feb 2015 08:42:40 +1100
> > Subject: RE: [MS_AccessPros] Missing First Names
> >
> >
> >
> >
> > Thanks Duane,
> >
> > The field is a Yes/No field and, unfortunately, the revised SQL also
> > produced no names.
> >
> > Regards,
> >
> > Robin
> >
> > At 21/02/2015 08:27 AM, you wrote:
> >
> >
> > Robin,
> > Is the convenorGenderMale field actually text or is it a Yes/No field.
> > If it's Yes/No try this expression:
> >
> > Convenor: IIf([convenorGenderMale],[mFirstName],[fFirstName])
> >
> > Duane Hookom MVP
> > MS Access
> >
> >> To: MS_Access_Professionals@yahoogroups.com
> >> From: MS_Access_Professionals@yahoogroups.com
> >> Date: Sat, 21 Feb 2015 08:19:10 +1100
> >> Subject: [MS_AccessPros] Missing First Names
> >>
> >> I have a database of residents and the activities for which they are
> >> convenors. Residents are a mixture in single females, males and
> >> couples. To determine the resident first name I am using this SQL in
> >> a query. It does not give me any first names. What have I missed?
> >>
> >> Convenor: IIf([convenorGenderMale]="yes",[mFirstName],[fFirstName])
> >>
> >> Many thanks,
> >>
> >> Robin Chapple
> >
> >
> >
>
>
>------------------------------------
>
>------------------------------------
>
>
>------------------------------------
>
>Yahoo Groups Links
>
>
>