iif(isnull( in Query

[grubbyr]

I have a [Company] and or a [Contact]
The Client: is the [Company] if the [Company] isnull then [Contact]

How do i put this in a query statement

 

[Rob Parker]

Client: IIf(IsNull([Company]),[Contact],[Company])

HTH,

Rob

 

[grubbyr]

Client: IIf(IsNull([Company]),[Contact],[Company])

HTH,

Rob

The Client: is the [Company] if the [Company] isnull then [Contact]

How do i put this in a query statement- Hide quoted text -

- Show quoted text -

Thanks for that