M
MsTrixie
Guest
I have a few Left and Mid functions in my database that seemed to work yesterday but now they don't they look just fine to me but I keep getting Compile error. in query expression.
I am trying to concatenate the current first two letters of the group with the T so the records will change with an update query.
ex: CAP updates to CAT
Here it is....
Left([Sales Order Summary Data]![GROUP],2) & "T"
I am trying to concatenate the current first two letters of the group with the T so the records will change with an update query.
ex: CAP updates to CAT
Here it is....
Left([Sales Order Summary Data]![GROUP],2) & "T"