Deleting single column information 2

[rotschreck]

My database is already pretty filled with relations attached to many tables.<br>
<br>
In one of my tables, I have to clear the data from one column but the column can't simply be deleted.<br>
<br>
suggestions? <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Maitredudonjon's</a><br>

 

[JimConrad]

Please supply more information.<br>
<br>
I assume you know how to use an UPDATE query to set the column to NULL. Or is that what you need to know?<br>
<br>
Or is the problem that you would like to set the column to NULL but one (or more) of the relationships will not allow it?<br>
<br>
Are you asking for help in determining which tables are involved in a relationship with the TABLE/COLUMN you want to clear? <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[rotschreck]

Actually...an update query set to null? Sounds like what I need. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Maitredudonjon's</a><br>

 

[rotschreck]

this only deletes the whole record, not the field in question. I need to keep the records intact for the presentation, and I need the existance of the field to still be there.<br>
<br>
I need the info in 2 fields (columns) to be deleted from over 2000 records. *sigh* is this possible? <br>
<p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>

 

[JimConrad]

An UPDATE query does not delete rows.<br>
<br>
Please send me an email with the details of what you are trying to accomplish. I can then send you an example .mdb <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>