Syntax error in query (1 Viewer)

[lmcc007]

I need to create requery that will list all addresses from tbladdress with the company name. If there is no company name (due to blind ads), it should list the CompanyID. In Query1 I added this calculated field:

Company: IIf(IsNull[qryCompanyNameDefault]![CompanyNameTitle]),"Company ID " & [tblAddress]![CompanyID],[qryCompanyNameDefault]![CompanyNameTitle])

But I keep getting the following syntax error:

The expression you entered contains invalid syntax. You may have entered an operand without an operator.
​

Should I do this another way?

Thanks for your help.

 

[John Big Booty]

Try;

Company: IIf(IsNull[B][COLOR="Red"]([/COLOR][/B][qryCompanyNameDefault]![CompanyNameTitle][COLOR="Red"][B])[/B][/COLOR]),"Company ID " & [tblAddress]![CompanyID],[qryCompanyNameDefault]![CompanyNameTitle])

 

[boblarson]

Try;

Company: IIf(IsNull[B][COLOR=red]([/COLOR][/B][qryCompanyNameDefault]![CompanyNameTitle][COLOR=red][B])[/B][/COLOR]),"Company ID " & [tblAddress]![CompanyID],[qryCompanyNameDefault]![CompanyNameTitle])

P -

You put in one too many parens for the fix. It only needed one:

Company: IIf(IsNull[B][COLOR=red]([/COLOR][/B][qryCompanyNameDefault]![CompanyNameTitle]),"Company ID " & [tblAddress]![CompanyID],[qryCompanyNameDefault]![CompanyNameTitle])

 

[John Big Booty]

I did too

 

[lmcc007]

P -

You put in one too many parens for the fix. It only needed one:

Company: IIf(IsNull[B][COLOR=red]([/COLOR][/B][qryCompanyNameDefault]![CompanyNameTitle]),"Company ID " & [tblAddress]![CompanyID],[qryCompanyNameDefault]![CompanyNameTitle])

Thank you, thank you!

 

[lmcc007]

I did too

That did it, thanks a bunch!