Append Data to Overwrite Existing Records

[leadpro]

I need to append data to a table, but instead of adding these records to the table, I need to overwrite certain values that already exist.

Indexed on [OrderNumber] and need to overwrite the fields [LeadsDelivered], [LeadsReturned], [CurrentBalance]

Thanks,

Leadpro

 

[PHV]

Have a look at UPDATE instead of INSERT INTO.

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