.------[ stephen wrote (2001/10/27 at 22:13:10) ]------| | i was wondering if it's possible to make a delete query to
deleteonly one | of the two fields in a table. I have tried only putting that field as | the "from" but it still
deletesthe other field also?| | Is there a macro or module code i could use? your help would be much | appreciated|
`-------------------------------------------------
No you can't delete a field, delete is only for entire rows.
What you'll want to do is UPDATE the field(s) in question to NULLs.
--------------------------------- Frank Wiles <frank@wiles.org>
http://frank.wiles.org---------------------------------