dim ssql as string
dim strwh as string
strwh="月度='" & me.月度.value & "'"
if Dcount("*","tbl0",strwh)>0 then
ssql="DELETE * FROM tbl0 WHERE " & strwh
docmd.runsql ssql
end if
ssql="INSERT INTO tbl0 (字段列表) "
ssql=ssql & "select 字段列表 from 交叉查询"
docmd.runsql ssql