How to increment a calculated field?

[KENTOY]

Can anybody show me how to increment a calculated field based on a continous subform.
I want to display the line number for every order he makes.

thanks

kentoy

 

[scriverb]

The following SQL can be used as a guide for the query of your subform. You will have to update the table name, field name, and add additional fields to the select that you need for your subform.

SELECT Count(*) AS LineNo, tblYourTable.OrderNumber
FROM tblYourTable, tblYourTable AS tblYourTable_1
WHERE (((tblYourTable_1.OrderNumber)<=tblYourTable.OrderNumber))
GROUP BY tblYourTable.OrderNumber
ORDER BY Count(*);

Let me know if you need additional assistance with this.

Bob Scriver