查询生成自动ID问题

liwen

查询 [A]： SELECT S排产指令单明细.单号ID, S排产指令单明细.销售订单
FROM S排产指令单明细
GROUP BY S排产指令单明细.单号ID, S排产指令单明细.销售订单;


查询：SELECT A.单号ID, A.销售订单, DCount("[销售订单]","A","[单号ID]=" & [单号ID] & " and [销售订单<='" & [销售订单] & "'") AS 序号
FROM A
或
SELECT a.单号ID, a.销售订单, (select count(*) from a as b where b.单号ID=a.单号ID and b.销售订单<=a.销售订单) AS 序号
FROM a

但由于同一单号销售订单并没有其他参照排序，序号只能按销售订单升序或降序排列。