Two Address Details

[McFestoe]

I have a table that contains customer info, site address etc the problem is the site address is sometimes different than the invoicing address, so i have created some more fields, inv_add etc. How do i get the report the check if there is data in the inv_add and use this instaed of the site_add infromation.

Thanks

 

[MajP]

use and unbound calculated field
=iif(expression, true response, false response)

=iif(not isnull([inv_add]),[inv_add],[site_add])

 

[dhookom]

You should be able to use Nz() like:

=Nz([inv_add],[site_add])

If the Inv_Add field is Null then the Site_Add will be displayed.

Duane
Hook'D on Access
MS Access MVP