Insert (-) in a string

[DaveT99]

This is really really bugging me, the update query works in a test database perfectly, i.e. inserts a dash after the 4th character, but as soon as a I paste the same criteria in my main database " "are added to the field name, see below

I Have inserted both queries design view in a pdf, and repeated here,



Left(New_MPN,4) & "-" & Mid(New_MPN,5) and in the main db when pasted to the upate query changes to Left("New_MPN",4) & "-" & Mid("New_MPN",5)

Really appreciate if anyone can spot WHY

Dave

[isladogs]

Try enclosing New_MPN in square brackets.
Make sure you remove the quotes in your update criteria.

[ranman256]

always put brackets around field to not confuse the query with litterals...

Left([New_MPN],4) & "-" & Mid([New_MPN],5)