autoincrement in a querry

[Computerpak]

In a querry I want the records to start from a number other than 1 and then autoincrement by 1.
When we click on to run the querry, a screen should popup asking what number you want to give to first record and then autoincrement by one.
I need a SQL syntax for this.
Could someone help me

 

[JoeMiller]

Try this web page, it should get you started in the right direction:

http://www.mvps.org/access/tables/tbl0005.htm

HTH Joe Miller
joe.miller@flotech.net

 

[Computerpak]

Dear JoeMiller
The procedure on those web pages is regarding, changing the autoincrement number in table not in querry

 

[JoeMiller]

I'm sorry, I misunderstood the question. I have a sample database that does what you're talking about that I can send you if you provide an email address. You can also view the web page that I based my sample on here:

http://www.fabalou.com/Access/Queries/RunningTotalQuery.htm

That page doesn't do exactly what you're looking for, but it can be adapted, which is what I did in my sample.

HTH Joe Miller
joe.miller@flotech.net

 

[Computerpak]

My email address is amerhabib@computerpak.com
Please send me a copy of that sample database
Regards
Amer Habib
amerhabib@computerpak.com