主题：[求助]筛选逻辑列、控件显示信息问题

1、Tables("表A").Filter = "日期 < #" & Date.Today.AddDays(-10) & "# and (逻辑列1 = false or 逻辑列1 is null or 逻辑列2 = false or 逻辑列2 is null)"

 

2、e.form.controls("Label1").Text = Tables("表A").Compute("count(日期)", "日期 = #" & date.Today & "#")

分组统计获取最后的日期，然后再筛选

 

select 车牌, max(日期) as 最后日期 from {表A} group by 车牌

 

http://www.foxtable.com/webhelp/scr/2321.htm

 

http://www.foxtable.com/webhelp/scr/2329.htm

 

select * from {表A} as a inner join (select 车牌, max(日期) as 最后日期 from {表A} where 项目a=false or 项目b=false group by 车牌) as b on a.车牌 = b.车牌 and a.日期 = b.最后日期 where DateDiff('d', 日期, Date()) > 10

之前的sql语句，是对于access的，如果是sqlserver数据库，这样写

 

select * from {表A} as a inner join (select 车牌, max(日期) as 最后日期 from {表A} where 项目a=0 or 项目b=0 group by 车牌) as b on a.车牌 = b.车牌 and a.日期 = b.最后日期 where DateDiff(d, 日期, getDate()) > 10

select * from {表A} as a inner join (select 车牌, max(日期) as 最后日期 from {表A} group by 车牌) as b on a.车牌 = b.车牌 and a.日期 = b.最后日期 where DateDiff('d', 日期, Date()) > 10 and (项目a=false or 项目b=false)