I have some data that comes in daily that should never be put in the table more than once. I have even set up error traps to keep this from happening but it still happens. I put the file name in the table of new data. I then assign the fielname to a varible and search the holding table for the filename. If it is not found, I append the new data into the holding table. I also change the name of the data file. If someone tries to input the same data in the holding table with the new file name, the program will let them do it because the filename is not found giving me duplicate data in the holding table. Is there better way of doing this? IS there some quick code I can use to find duplicates?
Thanks in advance for your help!
Randall
Thanks in advance for your help! :-)
Randall L. Johnson