Update Query Varriables 1

[jordanking]

Hello,

Is there a way to use an update query where the value to be updated is only appended to the existing value.
in ACCESS 2002

for exaMPLE:

UPDATE tblReturns LEFT JOIN tblCustomer ON tblReturns.lCusID = tblCustomer.idsCustomerID SET tblCustomer.lngzAccountStatus = 2, tblCustomer.memInfo = "CC DECLINED"
WHERE (((tblReturns.F10) Not Like "APPROVED           *                    ="));

I want the "CC DECLINED" to be added to the end of the memo field and not just replace the entire contes of the field.


Basically I want to get around having to execute another query to capture that value and then pass the concantenated values to the update query.

JK

 

[PHV]

Something like this ?
, tblCustomer.memInfo = tblCustomer.memInfo & " CC DECLINED"

BTW, not sure you may update tblCustomer due the LEFT join ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jordanking]

Thanks,

works great!