Auto Number rows

[Ebes1099]

Is there a way that I can create a field that will auto number the rows in a continuous form I'm using. I have a subform on a form, the subform is based on a query and I want to be able to number the rows. Any ideas?

 

[MajP]

You can number the rows using a query. I assume you want a dynamic number. Here is an example. You may need to provide your query for a better example.

select count(B.fldTwo) +1 as LineNumber
     , A.fldTwo
     , A.fldOne
  from tblOne as A
left outer
  join tblOne as B
    on A.fldThree = B.fldThree 
   and (
       A.fldTwo > B.fldTwo
    or A.fldTwo = B.fldTwo
   and A.fldOne > B.fldOne
       )   
group 
    by A.fldTwo
     , A.fldOne