Query Help

[Cadteach]

I have a database which lists address in one field and a field named "DISPLAY" which is a Y/N field. The database gets updated weekly. All addresses are in the database originally after update. I'd like to use the Y/N field to show or delete the address field. If the field is N, then the address gets deleted.

I'd like to use a query just after the weekly update to accomplish this, but I have never written anything more than some simple select queries.

Any help for a newbie?

 

[Cadteach]

Would this statement work?

UPDATE tablename SET address=" " WHERE Display="N

 

[garyk01]

DELETE FROM tablename WHERE fieldname='n';