Bounceback email deletes

[zumie]

I'm desperate!

My boss has given me a database with 77K+ records. One of the columns in the "names" tbl is "email_address". Then she gives me a list of 300 bounced back email addresses (no longer valid). She wants me to write a quiery to delete the email address in the "email address" column of the "names" table aond replace them with 0.

I'm not a dbase/Access programmer. I'm an IT guy. PLEASE HELP!

Zumie



Visualize whorld peas.

 

[ZmrAbdulla]

Is there any common field that can recognize the records that have bounceback emails?
If yes then create an "update query" with a where clause.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[zumie]

Yes, the email field.

Zumie



Visualize whorld peas.

 

[ZmrAbdulla]

Suppose you have the list of bouncing ids in a table called "tblBounceList" and the field name is "fldBouncingEmailID"
Your original list is in "tblOriginal" field name called fldemail"
Your query should be something like

UPDATE tblOriginal
SET fldEmail = 0
WHERE fldEmail
   IN(SELECT fldBouncingEmailID FROM tblBounceList)

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[zumie]

Thank you Zameer !!!!!!!!!!

You are a life saver

Zumie



Visualize whorld peas.