SQL Address Expression

[JLAZ]

Im using access to generate a confirmation letter for my company.

I need to address the letters which wouldn't be a big deal but I have to flip flop between fields depending on certain cercumstances.

For every place there is the physical address
For some there is a mailing address
For others there is a facility owner

Well if there is a facility owner I need the letter to go there
If there is a mailing address I need the letter to go there and have the care of there if there is one.
If there is niether then it will go to the physical address

I'm sure there is a simple way of doing this but I don't know SQL very well. I'm just a self taught user who plagerizes SQL and VB from others

Attached is an exaple of the table and the report.

 

[Rich]

=Iif(IsNull([FacilityOwner]),[MailingAddress],[FacilityOwner])

 

[JLAZ]

Hey Rich,

Thanks for the help It Seems to work but, i haven't thouroughly tested it yet

got caught up in another DB project.