如何将新发票的号码字段重置为0

大家好，


我正在使用Access打印发票。在每张发票上都有一个行号列，该列是为产品购买的每一行编号的字段。我想知道是否有办法将每个发票的号码字段（行号字段）重置为0。对于每次购买产品，这将增加1。示例如下：


我 nvoice＃ 行号 产品 价格

0123 1糖$ 10.00

0123 2大米$ 10.00

0123 3豌豆$ 5.00

0155 1香蕉$ 2.00

0155 2橙色$ 5.00

0159 1豌豆$ 4.00


感谢您的帮助。以上列表不是我想要的格式。但只需为每件商品标注包含行号的发票。但是，当创建新发票时，将重置行号。还有一种方法可以使用自动编号增加旁边的数字。

Hi All,

I am working in Access to print Invoices. On each invoice there is a line number column which is a field to number each line for a product purchase. I would like to know if there is a way to reset the number field (line-number field) to 0 for each invoice created. This would be incremented by 1 for each product purchase. Example below:

Invoice # line number product price
0123 1 Sugar $10.00
0123 2 Rice $10.00
0123 3 Peas $5.00
0155 1 Banana $2.00
0155 2 Orange $5.00
0159 1 Peas $4.00


Thanks for your help. The above list is not format as I would like. But just picture an invoice with line numbers for each item. But when a new invoice is created the line number is reset. Also is there a way to increment the numbers beside using autonumber.