IIF statement

[Julie]

Hi All! I have a question about the IIF statement. Can
I use this statement to combine 3 different fields
containing 3 different parts of a phone number.

For example:

111 111 1111
222 222 2222
333 333 3333
444 444 4444
555 555 5555

I want the output to be: 1111111111, 2222222222, and so
on. I don't need any spaces of dashes of any kind. Is
this possible? Thanks in advance for any help and have a
great weekend.

Julie

 

[Bob Barnes]

Yes, do you know how to concatenate strings?

If so, in yout T/F conditions of the IIF, just concatenate
the appropriate fields...

IIF(IsNull(AreaCode),FirstPart & SecondPart,AreaCode &
FirstPart & SecondPart).

HTH - Bob

 

[Julie]

Hi Bob! Thanks for your response. I had done something
similar to this, but it didn't work. I separated it with
commas instead of using the & symbol. Your example
worked. Thanks so much and have a great weekend!

Julie

 

[Bob barnes]

Glad to help. You also have a great weekend.

Bob

-----Original Message-----
Hi Bob! Thanks for your response. I had done something
similar to this, but it didn't work. I separated it with
commas instead of using the & symbol. Your example
worked. Thanks so much and have a great weekend!

Julie
.