I have table name transactions.
namecompany price expdate
ab1 2 22/9/2004
ab2 4 21/9/2004
ab2 5 21/9/2004
ab3 3 21/9/2004
ab4 1 21/9/2004

I want to delete the expdate of namecompany ab2 and price 4. So the result should be

namecompany price expdate
ab1 2 22/9/2004
ab2 4
ab2 5 21/9/2004
ab3 3 21/9/2004
ab4 1 21/9/2004

How can I write Sql (I use Microsoft Access 2000)

update transactions
set expdate = null
where namecompany = 'ab2' and price = 4

Oh... Thanks you very much. It work now.