UPDATE QUERY, I WANT TO LEAVE FIELDS AS THEY ARE IF NO MATCH FOUND 1

[franksirvent]

Hi
I got the following UPDATE code which updates a field called 'Service' when a match is found.

However I want the Query to leave 'Service' field as it is if no record is found.

Somehow the query below BLANKS the 'Service' field if no match is found...which is not what i want it to do...

The thing is that sometimes I already have data in the 'Service' field and I don't want it to be blanked, I only want the data to be replaced if a match is found.

Any ideas ?


UPDATE [Global Buying Rates1] LEFT JOIN [BAF Rates] ON ([Global Buying Rates1].ShippingID = [BAF Rates].ShippingLine) AND ([Global Buying Rates1].POD = [BAF Rates].POD) AND ([Global Buying Rates1].POL = [BAF Rates].POT) SET [Global Buying Rates1].Service = [BAF Rates].[Texto1] WHERE ((([Global Buying Rates1].GRIID)=1478));

 

[PHV]

Replace this:
LEFT JOIN
with this:
INNER JOIN

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

 

[franksirvent]

that does it !!!!

thanks mate !!!

a star for you !