>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

Hi Randall,

Perhaps when you rename the file after entering the data the 1st time, you should put the date in the name of the file. i.e. D04112001.txt. Then before allowing the entering of data check to see if the current day's renamed file exists. If so, then you know it has been entered.

HTH
Mike