Help in getting Address or PO Box in Address Directory

[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

 

[Jeff Boyce]

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

 

[John W. Vinson]

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

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

should work, if I understand your table structure correctly.

 

[Jeff Boyce]

John

Now that's ... 'elegant'!

Jeff B.

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

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

should work, if I understand your table structure correctly.