tabelA：

id name postdate
1 aaa 2006-6-1

2 bbb 2006-6-3

3 aaa 2006-6-1

4 bbb 2006-6-3

用一条SQL语句查出

1 aaa 2006-6-1

2 bbb 2006-6-3

也就是说将同时满足 name postdate 的重复记录去掉

willDel=false

sql="select count(*) from table where [name]='aaa' and postdate='2006-6-1'" '这里假设postdate是字符串
rs.open sql,conn,1,1
if CInt(rs(0)) > 1 then
willDel=true
end if
rs.close

if willDel=true then
conn.execute("delete from table where [name]='aaa' and postdate='2006-6-1'")
conn.execute("insert into table ([name], postdate) values ('aaa', '2006-6-1')")
end if

conn.close

'把'aaa'和'2006-6-1'改成变量就行了

还是专业的SQL论坛的人够专业些

解决办法式些

https://bbs.bc-cn.net/viewthread.php?tid=108640