is it possible to use something like the following to append text to a field instead of overwriting.

        .Edit
        !a2 = scost
        .Update
I would like to add "scost" to what ever might be there seperated by ~
eg
sretail~scost
in field a2

many thanks

Hi,
Not too sure what your trying to do but you could append by

        temp= !a2
        .Edit
        !a2 = temp & "scost"
        .Update

Regards

Hi, it might be useful (or not) to know that you can also concatenate in a batch update. just include in the update SQL:

UPDATE tablename SET a2 = a2 & 'scost';

and execute the command and every record in tablename will be updated.

If you keep running this command though, you will end up with scostscostscost...etc on the end of the a2 value :-)

thanks for that.
will have to go with the (temp & "sCost")

although the sql would be faster, I'm just a beginner and don't know how to execute an update statement in code.

Thanks anyway