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 (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar