Append query also updating earlier records

[humph]

Can anyone help me with this - I have an append query to a statement table for invoices with a macro set. When the query is run the data is added to the statement query.

what is happening is that it is adding the data ok on a seaparate line but is also updating any previous invoices for the same client to the new invoice number obviously not what I want.

many thanks

Regards

Humph

 

[gemma-the-husky]

probably need a where invoice number is zero or blabk, within the update expression.