View Single Post
  #2 (permalink)  
Old March 6th, 2005, 06:29 PM
echovue echovue is offline
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Personally, I would change the query type into a Make Table query. Once the new table is created, I would go to design view, and add a column of type autonumber. Once save this field will automatically populate itself with sequential numbers.

Hope that helps,

Mike

Mike
EchoVue.com
Reply With Quote