Delete Queries

[GarageFlower]

Morning

I Have done a search but have not found an answer

I ran a delete query and specied fields to be deleted from certain records.
Instead of deleting the field it trys to delete the entire record.

Any ideas how i can get it to just delete fields and not the entire record.?

 

[checoturco]

update the table instead of delete

 

[GarageFlower]

i have done that and it says

query must have at least one detination field?

 

[GarageFlower]

Right ok i have this working

I am running an append query and an update query

The problem i have is

Im specifying 7 different filelds to append and update

The thing is if one of the fields is blank to start with the whole thing wont work.
Each field needs to have an entry in it otherwise it wont work.