Need query to edit 1st 3 characters of a column if criteria met

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have been trying to use "setvalue" for the action, table and column heading
for item and Right(column heading, 5) for the expression. What a i doing
wrong or not doing?

Thanks
 
Are you doing this in a form? in a table? in a query? Please, more
information about your setup and when/where you're wanting to do this.
 
Balloons,

I agree with Ken that you have not provided enough information for
anyone to give much help. However, I can say that if you are trying to
relate to a table with the SetValue macro, you are unlikely to be
successful. Normally this action refers to a control or property on a
form. I would suspect that an OpenQuery action to run an Update Query
is possibly closer to what you need.
 
Back
Top