Hi there,
I am combining the records of two tables. The first table (main) is opened and the second table (merge) is opened and then I go through the second table one record at a time and make sure the record doesn't exist in the first table before I add it to the first table. The main table has 5 records and the merge table has 10,000 records. I have cdx's built for each table.
My code is taking about 8 minutes to process. Does that seem extremely long for only 10,000 records? What other issues should I be looking for?
Thanks for any help you can provide.
Scott Starkey
"You are in a postion to demand............nothing!"