Delete query to target fields not rows?

[MrCee]

Hi

I need to know if it is possible to create a delete query which will target particular fields in a row based on certain criteria in a seperate combo box(on same table).

The few ways that I have tried to do this have been unsuccesful so if anyone can shed some light on the subject it would be greatly appreciated.

 

[neileg]

Not 100% clear on what you want to do, but I supect that an update query may give you what you ask for.

 

[MrCee]

Delet query problem

Hi Neil

i have had a look at update queries but cant see a way to make it happen from there.

I will try to be a little clearer in what I need.

I have a Table which contains 6 fields.

For the purpose of this explanation i will have the fields numbered 1 to 6.

I want to run a delete query based on criteria in field 6.

I am hoping that this delete query will be able to delete the data stored in fields 3,4, and 5 only.

I am fairly new to access so this may be a basic question, not sure.

Any help is appreciated!

 

[Dennisk]

Delete queries will delete entire rows. whereas you want to update fields 3,4,and 5 if certain criteria is met in field 6. Search Access help for UPDATE.

 

[neileg]

I was thinking that you would update fields 3,4 & 5 to zero or empty text.

 

[MrCee]

Thanks

Thanks for your help guys, that sounds like a much easier way to do this.