Originally Posted by
lccrews
The portion DoCmd.OpenQuery "qry_CurrentFormula_Pt4" has a field that relies on qry_CurrentFormula_Pt3 where the formula Left([Raw Material],6) resides.
Maybe post a screen shot of the query designs and the sql's? I'd agree that the reference should have no bearing on the Left function. I guess those are not Select queries. Exactly which line presents the error?
Last edited by Micron; 04-27-2018 at 05:34 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.