7,714
社区成员
发帖
与我相关
我的任务
分享
ff = "1=1"
If Me.Name <> Null Then
ff = ff & " and [tb1].name='" & Me.Name & "'"
End If
If Me.age <> Null Then
ff = ff & " and [tb2].age='" & Me.age & "' "
End If
DoCmd.RunSQL "select * into [temp] from [tb1] a left join [tb2] b on a.ID=b.ID where " & ff
Me.window.SourceObject = "表.temp"
.