i have a query that appends first & last name together using
Customer Name: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))
I would like to add home PH Bus PH and M Ph so i can populate a text box with
John Smith 112334567 1234455 04156787
The purpose of this is so i can make appointment in calendar (from access) where the subject line has name and ph for fast lookup and i don't have to add the person to contacts.
Currently keep getting wrong number of augments. All are from the same table. Also some ph no.s may be null
thanks appreciate the help