Number the rows in a query

[lucy6868]

I have this formula that I copies from a website somewhere that numbers the records in a query so I can use it to populate a journal entry screen in my accounting software:

Line: IIf(CInt(DCount("Description","tblPayrollJE","Description <='" & [Description] & "'"))<33,CInt(DCount("Description","tblPayrollJE","Description <='" & [Description] & "'")),33)
It only works on a text field where each record is unique.
Is there a way to change it so it will work on an integer field? I added an autonumber field to my table to use as a basis but the record count need to always start with 1.

Any help would be appreciated!

Stephanie

 

[pilsdumps]

Insert your records into a new table with an autonumber field and select from that and include the field.

 

[gemma-the-husky]

personally, i dont think i would bother number the transactions for storage - unless you do it on entry - just number them on the printout