创建一个按钮来查找最近七天建的单,如果同一个字段的订单行数量超过3条的把所有的这个字段显示出来,按钮双击语法:
Dim dt As Date= Date.Today.AddDays(-7)DataTables("拍单表").LoadFilter = " [字段] In (Select [字段] from (Select [字段],count([字段]) As 计数 from {拍单表} group by [字段] where [接单日期] <=dt) where 计数>=3) "
DataTables("拍单表").Load()
提示错误: