Count

[tomk01]

Im want to create a table that looks like this
Field
1
2
3
4
5
...

I was thinking somthing like this
Code:
SELECT record count (id) as num
into tempint1
from einfo
group by id

the problem with my statment is it returns this:
field
1
1
1
1
1
1

 

[bboffin]

Is there any reason why you can't use an AutoNumber column which will do exactly what you want and requires no coding?


Bob Boffin

 

[tomk01]

I have to drop the table and recreate it evrey time my quary runs

 

[JonFer]

You can run an ALTER TABLE query afterwards to add the Autonumber field.



John

http://www.interautomateconsulting.com

 

[cmmrfrds]

You are close, just join the table back to itself. See this thread.

Thread705-947425