Queries

[mercwonder007]

I have 3 phone fields (Phone, Cell, OtherPhone) I need to create a query that will show the phone numbers in a cingle collumn. I want to show the phone number field first, if that is blank then move on to the Cell phone, if that is blank them move on to the otherphone, if all three are blank then show a message that says, "Get phone number" Any help with this would be greatly appreciated. Thank you.

 

[Blorf]

Hi.

iif (Phone is null, iif (Cell is null, iif (OtherPhone is null, "GetPhone", OtherPhone), Cell), Phone)

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[mercwonder007]

Thank you i'll give it a try.