如何给查询加序号

http://www.accessoft.com/article-show.asp?id=4429

趣谈子查询，这里就有一个查询中编号：

Select (select count(*) from 基础查询 as b where b.物资ID=a.物资ID and b.日期<=a.日期) AS 序号, a.日期, a.物资ID, a.名称, 期末+发料-收料 AS 期初, a.收料, a.发料, (select sum(b.期初+b.收料-b.发料) from 基础查询 as b where b.物资ID=a.物资ID and b.日期<=a.日期) AS 期末
FROM 基础查询 AS a