Solved

appending name & ph access 2010

Posted on 2011-03-13
2
407 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

757 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

18 Experts available now in Live!

Get 1:1 Help Now