Search results
-
R
Problem deleting duplicates from a huge table!
MANY THANKS! Thanks Guys, All of your ideas were helpful and I tried them all. The one that worked for me was Pat Hartman's idea. Thanks Again, Robbie -
R
Problem deleting duplicates from a huge table!
Hi, I have a table with about 15,000 records in it. I need to delete all but one of each duplicate social security records. I have tried solutions in other posts on this board such as... A. Using the find duplicates query which completely ignores half of my records when done. B. Index the... -
R
Query columns with no specific order
Thanks Fornation, You answered part of my question, but I think I left out one aspect of the problem. The data does not only consist of the word "Johnson". It might be "Anna B. Johnson" or it might have a title included in the field. The information is being drawn from different source... -
R
Query columns with no specific order
I have a large query of 70,000 records or so. Four of the columns in the query contain name, address, state, and zip but in no specific order. One record may have the name in the 1st column while the next record might have the name in the 3rd column. These columns are named reg1,reg2,reg3,&...