By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,502 Members | 3,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,502 IT Pros & Developers. It's quick & easy.

I need to edit customers with certain ZIPCODES

P: 1
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
Mar 12 '08 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
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
Mar 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.