Increase number by 1

[elstiv]

I have been trying this for a whole day to no success. I have created a simple Select Query showing data from various tables. I now want to add a column in my Query called CUSTOMER_NO which simply shows a number (for example 500) for the first query result and then add 1 to each subsequent result in the query. For exmaple this is what I want in the result of my select query:



Name Surname CUSTOMER_NO
Joe Smith 500
Harry Potter 501 etc

I have an auto ID but i do not want to use that, all i want is to generate a number (such as 500) and increment it by one in the select query. I do not want this number to be stored anywhere just shown in the select query results.
Please help. Thanks

[ssanfu]

Check out "rogersaccesslibrary.com".

There is a page "NumberedQuery.mdb (beginner)" at:

http://www.rogersaccesslibrary.com/forum/topic309.html

This sample illustrates two different ways to create a query with a sequenced number column.

(select the Access 2000 version)

[elstiv]

many thanks i will give it a try and post back