access 中使用sql切分查询 客户时刻群之前的记录

SELECT * INTO tbefore
FROM (select * from 
DATA 
INNER JOIN
(
select cut.cu,format(min(cut.t),'yyyy/mm/dd') as firt
from
(
SELECT  DATA.[客户编号] as cu ,DATA.[下单时间] as t FROM  DATA 
WHERE  FORMAT(DATA.[下单时间],'yyyy/mm/dd') between '2017/02/01' and '2017/07/01'
and
DATA.[产品] like '*清明*'
) as cut
group by cut.[cu]
) as t1
ON DATA.[客户编号]=t1.cu
)  AS x1
WHERE (((DateDiff('d',[x1].[下单时间],[x1].[firt]))>0));