查询结果自动编号

完全用查询的方法实现编号：

SELECT (select count(b.id) from tblSale as b where b.company="Microsoft" and b.saleDate>=#2008/3/4# and b.id <= a.id) AS 序号, a.ID, a.saleDate AS 销售日期, a.company AS 客户名称, a.weight AS 销售量, a.salePrice AS 销售单价

WHERE (a.saleDate>=#3/4/2008# AND a.company="Microsoft");

要注意的就是将两者条件一至起来

仅供参考