I'm using Allen Brown's ConcatRelated function. In my query I get a syntax error for a missing operator. I have tried every possible combination of quotation marks, brackets, single quotes etc imaginable and can not seem to get it to work. I got incorrect results with a couple of my attempts but just can't get what I need.
Any ideas would be appreciated!! (All are text fields)
My current query:
SELECT MDTRegionalCFN
ConcatRelated("Region","Copy of Skus","MDTRegionalCFN = '" & [MDTRegionalCFN] & "' )
FROM CopyOfSkus;
Any ideas would be appreciated!! (All are text fields)
My current query:
SELECT MDTRegionalCFN
ConcatRelated("Region","Copy of Skus","MDTRegionalCFN = '" & [MDTRegionalCFN] & "' )
FROM CopyOfSkus;