Dim jb As New SQLJoinTableBuilder("统计表1","ACCxmdjb")
Dim bg As {ACCygdjb}.bgs 。。。。这里怎么写?
jb.C
jb.AddTable("ACCxmdjb","ygxm","ACCygdjb","ygxm") '关联列
jb.AddCols("{ACCxmdjb}.ygxm","xmfzr","gsmc","xmmc","dtmc","xmlx","gch","gxs","wcsj","sfsjwj") '显示的列
jb.Filter = "bgs = bg And sfsjwj = False" '筛选条件
jb.Distinct = True
jb.Build()
MainTable = Tables("统计表1")
我有一个ACCxmdjb(项目登记表),一个ACCygdjb(员工登记表),员工登记表有一列 bgs(就是所在办公室的号码如:1203),我现在想实现的查询功能时,当某人(项目负责人)登录时,点击查询按钮显示的结果只有本办公室人员的 项目登记信息,这个限制信息怎么写,请老师指导,谢谢。