Can anyone tell me how I can include a ‘Line Number’ field to a Query. I wish to add a field that increase by 1 for each record. (An Auto Number field won’t produce sequential numbers when it is filtered)

Any help appreciated


[This message has been edited by AlanW (edited 02-20-2002).]

[This message has been edited by AlanW (edited 02-20-2002).]

http://www.access-programmers.co.uk/ubb/Forum5/HTML/001172.html

Check out "How To Create an Auto Number For Each Row of Your Query." at http://ourworld.compuserve.com/homepages/attac-cg/AQryTip.htm

HTH,

Edward