delete query

[99mel]

Is it possible to delete only some of the fields in a form using the 'delete query'<br>
When calling a delete query from the form it deletes all the record. I've modified the query to only contain the fields that I want deleting but it stills deletes all of them in that certain record. Anyone have any ideas?<br>
<br>
Thanks

 

[Zelandakh]

Does it delete ALL the records, or does it only clear them from the screen? In other words, are you only missing a refresh data after running the query?<br>
<br>
If it is indeed deleting all records, then you need to change the query to filter in or out the records you actually want to delete.<br>
<br>
Can you post a little more info?

 

[99mel]

It does delete the record that is displayed from the form as well as from the actual table. The fields on the form then display '#Deleted'.<br>
I have made the query pick only the fields that I want but it still deletes all the fields in the record. The query shows the fields that I want, but when i run the delete query from the form it then deletes all the fields from that record, strange<br>
<br>
that manke any sense?

 

[Jonathan]

A delete query is designed to delete entire records from a table, not specific fields. If you want to clear the values stored in the fields then you should probably use an update query

 

[elizabeth]

More specifically, use the Update query to update the fields you want to &quot;delete&quot; to null, empty string &quot;&quot;, etc, based on their current value.