Alan's method will certainly do the trick. I'm wondering what kind of join you are using. If you are using an inner join, you should only get each account number once, provided there is only one account in each table. Can you provide your SQL statement?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
jgomez 
Register To Reply
Bookmarks