A查询有一字段值(LJ)是利用子查询得到的 select *,(select Sum(f1)from tbl where name=A.name And Date<=A.date) As LJ From tbl as A; 运行结果正常,如果基于A创建B查询,而B也有一字段是子查询的值 select *,(select Last(LJ)from A where name=B.name And Date<B.date) As QC From A as B; 运行B查询时出现access自动备份,提示发送错误报告并退出access系统。
问题二
报表基于A查询,A有一字段值(LJ)是利用子查询得到的 select *,(select sum(f1)from tbl where name=A.name And Date<=A.date) As LJ From tbl as A;
A查询有一字段值(LJ)是利用子查询得到的 select *,(select Sum(f1)from tbl where name=A.name And Date<=A.date) As LJ From tbl as A; 运行结果正常,如果基于A创建B查询,而B也有一字段是子查询的值 select *,(select Last(LJ)from A where name=B.name And Date<B.date) As QC From A as B; 运行B查询时出现access自动备份,提示发送错误报告并退出access系统。
问题二
报表基于A查询,A有一字段值(LJ)是利用子查询得到的 select *,(select sum(f1)from tbl where name=A.name And Date<=A.date) As LJ From tbl as A;