View Single Post
Old March 24th, 2008, 11:51 AM
thork1 thork1 is offline
Registered User
Join Date: Mar 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems with IIF

I am having problems with getting this to work..

I have a database which allows orders to be taken.
A check box can be checked and the delivery address will be the same as the invoicing address. I used this formula:
=IIf([Delivery address same as invoicing]=Yes,[Invoicing Address 2])
however, when its not the same, i still need to type an address in.
Anyone got any ideas?