Help

Can someone please tell me why I'm getting this error?
Why am I getting this error message?

Invalid bracketing of name

This is what I have:

Site_ID: IIf([BILL_CODES]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([qry_Symantec_email_Circ_A2_3.Site_ID])))


Thanks
Corey

Hi Corey

I suggest that you write the string as below. This will work

Site_ID: IIf([BILL_CODES]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([qry_Symantec_email_Circ_A2_3]![Site_ID])))

In this case it prefers to have the name of the query and field name separated by square brackets (Highlighted in red) with an exclamation point in between to identify the difference of the name and field

HTH

Martin

Martin,

That didn’t seem to work with, I didn’t get any error, but when I try to run it, it gives me the “Enter Parameter Value” box asking for “qry_Symantec_email_Circ_A2_3!Site_ID”
I also tried
Site_ID: If([BILL_CODES]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([qry_Symantec_email_Circ_A2_3].[Site_ID])))

That didn’t work either.

Any ideas?

Corey

Hi Corey

I know this sounds a silly question, but I presume you have the query [qry_Symantec_email_Circ_A2_3] within the query you are trying to write here and that you have joined it to the respective field in the table.

The reason I ask is, that the problem you are getting is a normal response when Access cannot find the field in the table/query.

Let me know and we will take it from there

Martin