-
I have a field in TableA called “ProductSKU” which is a primary field that concatenates some data from other fields in TableA. The formual is: LEFT(Description,10) &"-" &FinishCode &"-" &Model
-
I have a field in TableB called “SelectKit” that is a link to “ProductSKU”.
-
I have a third field in TableB that concatenates data from the “SelecKit” field. The formula is: LEFT({SelectKit},5)
Now, that we’ve established that. I have found that SelectKit is arbitrarily entering a single quotation mark as in " just before the text that is being pulled from “SelectKit”. This only happens in one case. I’ve checked all the fields from every other table and there is NO quotation mark entered in a field. I’ve checked the formulas and they all appear correct anbd otherwise working, except for one entry.
Why is this question mark being entered??