A azzurri Registered User. Local time Today, 02:39 Joined Feb 27, 2002 Messages 25 Jan 10, 2003 #1 I had try to use Delete query but it will delete the record totally, is there a way to delete certain fields from a record without deleting the record itself? Thanking in advance.
I had try to use Delete query but it will delete the record totally, is there a way to delete certain fields from a record without deleting the record itself? Thanking in advance.
A antomack Registered User. Local time Today, 02:39 Joined Jan 31, 2002 Messages 215 Jan 10, 2003 #2 Use an update query and update the fields you want emptied to Null.
A azzurri Registered User. Local time Today, 02:39 Joined Feb 27, 2002 Messages 25 Jan 10, 2003 #3 Thanx. Couldn't thought it would be to simple a solution.