Re: delete queires

.------[ 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---------------------------------