Pick One Field Or The Other

[matthoward]

Message to the Wise Ones.
I have a access database with the following,
Residential Address, Residential Address1, Residential Address2 and also Mailing Address, Mailing Address1, Mailing Address2, Mailing Address3. My big problem is that I have a number of customer who do not have a mailing mailing address just a residential one. My big question is that is their a formula that says if Mailing Address is empty use Residential address? Your help as always is greatly appreciated.

Cheers Matt

 

[lyanch]

There is, but it depends on how your data is in the database.. are mailing and residence addresses all on one row in the database?

Are they in the same table but with different "types"

Are they in completely different tables?

More information is needed...

Lisa

 

[matthoward]

The are all in the table I have called CLT001. Its list all my client information and in that I have the various Fields of Mailing Address and Postal address etc etc.

Cheers Matt

 

[lbass]

Try something like:

If isnull({CLT001.mailingaddress}) or
{CLT001.mailingaddress} = "" then
{CLT001.residentialaddress}

If the mailing address consists of multiple fields that you want displayed in address format, create separate detail sections for each line and in format section check "suppress empty section" for each, in case some lines are empty.

-LB