在查询中增加序号列

amonaly

上传的数据库中，“查询Temp”是对“表a11003，帐号”字段中，满足“帐号第9-10位为‘29’”，（公式＝Mid([A11003]![帐号],9,2)＝29）进行的筛选，但实际工作中需要对“查询Temp”新加一列序号重新编号，请教怎么做？

liwen

将查询改为如下语句

SELECT A11003.帐号, A11003.名称, A11003.借方余额, A11003.借方积数, A11003.贷方余额, A11003.贷方积数, A11003.币种, DCount("[帐号]","[A11003]","[帐号]<='" & [帐号] & "' and Mid([帐号],9,2)='29'") AS 序号
FROM A11003
WHERE (((Mid([A11003]![帐号],9,2))="29"))
ORDER BY A11003.币种;