Delete data from certain fields 1

[mrt1]

I have a table in Access 2002 that includes several date fields, including "deposit". The records also include a "location" field for one of four possible building sites. For records at "location x", the "deposit" fields were inadvertently populated with data - they should have been left blank - about 1500 of 5000 records. Other records for "location y" and "location z" have the correct dates in the "deposit" field and cannot be changed.

Is there any way I can delete the all the values in the "deposit" field for "location x" and leave the "deposit" data for the other locations alone?

 

[AlexCuse]

Something like this?

update table
set deposit = ''
where location = 'LocationX'

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[r937]

if deposit is a date field, as mentioned, then i rather suspect that setting it to an empty string will fail

how about setting it to NULL instead

;-)

r937.com | rudy.ca

 

[AlexCuse]

Yeah, setting the date column to null will work better I think.

Never take advice from a man who cannot read.

Ignorance of certain subjects is a great part of wisdom

 

[mrt1]

Thanks for the help. I tried AlexCuse first suggestion and it worked fine on a copy of my database. If I run into trouble with any of the empty string date fields, I'll try the second on another copy.