Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need Vba Loop to replace in clause
Thanks guys I changed the way my query was indexed and made sure I got rid of extra columns with respect to many to many relationship. I had a one to many and it seemed to be a big part of my issue. Then I just added distinct to my results and it pulls fast and perfect. Thanks again. With all...- PapaG39
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need Vba Loop to replace in clause
SkipVought, I have it set up right now were Table 1 has 2 zip code pairs in it. I then have a query that links Table 1 to the master zipcode table to pull in my results. It takes forever. I am open for any suggestions. Just as an fyi..I want to query thousands of zips so I thought some kind of...- PapaG39
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need Vba Loop to replace in clause
kjv1611, thanks for the post. The task is easy to explain but the results are slow right now because of the in clause. I think! Think of a static table with every possible zip code pair in the United States. Now pretend that you have a customer file with start zip and stop zip. I want to bounce...- PapaG39
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need Vba Loop to replace in clause
I have a static zip code table that I want use with a vba loop instead of using a large in clause. I believe this will speed up the seek time for each zip code pair. Static Table has from: and to: zip bouncing off of another query searching for a match. I just need to make the static table...- PapaG39
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
