Access Query expression builder error, please help.

[Maggie Barr]

Hello and thank you in advance for helping if you can,
I have an expression for building a calculated column in an Access query that has worked fine in the past, but I am trying to do it know, and because there is a query linked to this query with the same field, it is giving me "The specified field ‘[DAY_MONTH_VALUE]’ could refer to more than one table listed in the FROM clause of your SQL statement."

What I would like to know is how to reference the query eBird_ALL_DATA Query2 Base Data Output
for the expression:
OBS_DATE_ACCEPTANCE: IIf([DAY-MONTH_VALUE]<[START_Date_VALUE] OR [DAY-MONTH_VALUE]>[END_Date_VALUE],"OUTSIDE","GOOD RECORD")

so that it will use the variable in the expression from eBird_ALL_DATA Query2 Base Data Output. I tried some SELECT statements, but I could never get the syntax right and I am not sure if that is the right way to do it.

Thank you for your time,
Maggie
Oh my word, solved, but I can't delete post, so I figured it out and modified my equation to:
OBS_DATE_ACCEPTANCE: IIf([eBird_ALL_DATA Query2 Base Data Output.DAY-MONTH_VALUE]<[eBird_ALL_DATA Query2 Base Data Output.START_Date_VALUE] OR [eBird_ALL_DATA Query2 Base Data Output.DAY-MONTH_VALUE]>[eBird_ALL_DATA Query2 Base Data Output.END_Date_VALUE],"OUTSIDE","GOOD RECORD")

And that worked, sorry to clutter Mr. Excel!

 

[Joe4]

Add an object name qualifier in front of your field, i.e.

[table or query name].[COLOR=#333333][DAY-MONTH_VALUE][/COLOR]

Do this for all references to this field in your formula.