同一数据表中不同日期比较，如何取值？

SELECT T.账户名, Min(T.账户清单.余额日期) AS 账户清单_余额日期之最小值,Max(T.账户清单_1.余额日期) AS 账户清单_1_余额日期之最大值FROM (SELECT 账户清单.*, 账户清单_1.余额日期FROM 账户清单 INNER JOIN 账户清单 AS 账户清单_1 ON 账户清单.账户名 = 账户清单_1.账户名WHERE (((账户清单_1.余额日期)>=[账户清单].[余额日期]))) AS TGROUP BY T.账户名;