I have a database listing residents. The fields involved are
[fLastName] and [mLastName].
I need a new field [rLastName] which is to be a list of the last
names of single persons and married couples.
This one gives me single males only:
rLastName: IIf([mLastName] Is Null,[fLastName],[mLastName])
which I understand.
This attempt misses the single males but includes married males and
single females:
rLastName: IIf([fLastName] Is Null,[mLastName],Iif([fLastName] Is Not
Null,[fLastName],""))
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