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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dedupping query runs extremely slow, ideas on how to speed up?

Status
Not open for further replies.
pcrosby78

pcrosby78

Technical User
Feb 6, 2002
11
US
I have a mailing list that is a combination of several different tables.

I have written a union query to combine the list and then i have a dedupping query run on the combined list.

This takes extremely long, is there a way to get the same results but take less time?

(there is about 8 tables for the mailing list totally about 200,000 names)

Thanks for any input.
 
Status
Not open for further replies.

Similar threads

I
  • Question
How to get 2 codes to work together.
Replies
6
Views
212
hermanlaksko
hermanlaksko
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
219
Xavierparkash
Xavierparkash
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
461
TrekBiker
TrekBiker
qqp
  • Locked
  • Question
Looking for ideas on how to create an estimating form that would have a header and details under it 1
Replies
2
Views
230
qqp
qqp
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
327
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top