D
deb
I am trying to use an update query to change a field to a concatenated field
using the criteria below. In a select query, it works fine but in the updae
query, it cuts off at the first space in the field.
any suggestions?
(([ServerPath]) & (Mid([Photo],3,Len([Photo])-2)))
using the criteria below. In a select query, it works fine but in the updae
query, it cuts off at the first space in the field.
any suggestions?
(([ServerPath]) & (Mid([Photo],3,Len([Photo])-2)))