I am trying to use this wonderful function in a query, but I am getting the error:
Error 3075: Syntax error (missing operator) in query expression '[Company Name] = All 4 One, LLC'.
This is how my query is set-up - only thing I see different is that I have brackets, but some fields have spaces so they are needed.
What is incorrect in this element?
Code:cID: ConcatRelated("[cID]", "[Contractual Obligations]", "[Contract ID] = " & [Contract ID])