I have the SQL below to deliver "Mary Smith" as the female resident
when no male is shown as resident in the record and "Betty" to be
shown when Betty has a partner.
For some reason that I cannot understand the male residents are
exclude as expected but the female residents record [fFirstname] only
is included.
What have I missed?
Many thanks,
Robin Chapple
SELECT Telephone.ID, Telephone.Unit, Telephone.fFirstName,
Telephone.fLastName, Telephone.mFirstName, Telephone.mLastName,
Telephone.Phone, IIf([mLastName] Is Null,[fFirstName] & " " &
[fLastName],[fFirstName]) AS fResident
FROM Telephone;
__._,_.___
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