I need to edit customers with certain ZIPCODES

[hedda]

I need to link to our database at work and update our customer shipping information (16,000 customers).

I have a list of zipcodes (570) I only want to pull customers with or without the zipcodes on the list. I've tried using IN and building a (temp) table but nothing seems to be working.

I would like to find out how to do this using query, or a SIMPLE way!! Being linked to the live database, always makes me nervous!

THANK YOU

[Scott Price]

Where/how are you storing the list of zip codes?

You'll end up with a tremendously long sql string trying to run a query with 570 criteria...

It should be possible using VBA, but I doubt a simple query solution exists.

Please post your table structure and we can take a look.

Regards,
Scott