RE: [MS_AccessPros] Missing First Names

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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/