Nested if function in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can i use nested if in access? I am trying to put phone number into text
box. If there is no cell number i want to put home number, if both fields
are null i want to put work number. All 3 phone field are defined in Contact
form.Thanks
 
Greg

If your form is based on a query create an expression like:-

DN: IIf(IsNull([CellNo]),(IIf(IsNull([HomeNo]),[WorkNo],[HomeNo])),[CellNo])

Make the control source for your text box the name of the expression, in
this case, DN

Hope this helps.


Andy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a IF Statement within a Select Query. 2
Formatting issue with imported telephone number! 2
List box 4
Formula nesting with IF statements 2
Access 2007 1
Word Create a Phone Book using MailMerge in word 2007 0
Refreshing main form from the subform 1
Dlookup help for duplicate phone number entry and message box. 8

Back
Top