Solved

appending name & ph access 2010

Posted on 2011-03-13
2
413 Views
Last Modified: 2012-05-11
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

0
Comment
Question by:kcc12
2 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 35125601
Try:

CustomerName: IIf( IsNull([Last Name]) and IsNull([First Name]),[Company], Trim([First Name] & " " & [Last Name]))

with phone #'s

CustomerNamePhones: IIf( IsNull([Last Name]) and IsNull([First Name]),[Company], Trim([First Name] & " " & [Last Name]))  & " " & Trim("H: "+[HonePH] & " " & Trim("W: "+[WorkPhoe] & " C: "+[CellPhone]))

0
 

Author Comment

by:kcc12
ID: 35125678
works beautifully.
thank you
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Join multiple pivot queries 2 16
Please help with the below query - SQL Server 11 16
Access Crosstab Query with Multiple Values 4 31
Sql server insert 13 26
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now