Help in getting Address or PO Box in Address Directory

  • Thread starter Thread starter W. Guy Delaney
  • Start date Start date
W

W. Guy Delaney

I am trying to figure of how to write an llf statement that will insert tht
PO Box number into the Address Line of my Telephone Directory if the Street
Address is blank.

Can anyone write that statement for me?

Guy
 
Guy

That would really depend on how your table is structured.

If the table is reasonably well-normalized, your IIF() statement might look
something like (untested):

IIF(Len([AddressLine]>1,[POBox],[AddressLine])

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I am trying to figure of how to write an llf statement that will insert tht
PO Box number into the Address Line of my Telephone Directory if the Street
Address is blank.

Can anyone write that statement for me?

Guy
Click to expand...

NZ([Street Address], [PO Box])

should work, if I understand your table structure correctly.
 
John

Now that's ... 'elegant'!

Jeff B.

John W. Vinson said:
I am trying to figure of how to write an llf statement that will insert
tht
PO Box number into the Address Line of my Telephone Directory if the
Street
Address is blank.

Can anyone write that statement for me?

Guy
Click to expand...

NZ([Street Address], [PO Box])

should work, if I understand your table structure correctly.
Click to expand...
 
Back
Top