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
__._,_.___
Posted by: Robin Chapple <robinski@westnet.com.au>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar