expression query

[abrandi]

I am trying to build an expression stating - if Business Address field and Home Address field are used (not null) use Business field first.

I do not know if this can be done.

thanks for your help.

 

[mp9]

[Business Address] Is Not Null AND [Home Address] Is Not Null

http://www22.brinkster.com/accessory/

 

[DotNetGnat]

something like this:

IIF(((BusinessAdd IS NOT NULL) AND (HomeAdd IS NOT NULL)), BusinessAdd, HomeAdd)

-DNG

 

[PHV]

And this ?
Address: Nz([Business Address], [Home Address])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886