I am attempting to make the names of male residents from a database
where male and female first names are in separate fields. The last
name is common to both.
My failed attempt gives ne a "#error" without an indication of what I
have missed.
Status 3 and 4 are married couples and partnered couples.
mName: Iif([ResidentStatus]="3 or 4","",[mFirstName] & " " & [LastName])
What have I missed?
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