You're welcome! :-))
>You nearly made me choke on my coffee! :-)
>
>>Then you must add some more code....
>>
>>>thank you,it works
>>>but i need to replace my field typ with 1 where records is duplicated
>>>at mytable. or insert all duplicated records to newtable.
>>>