View Single Post
  #5 (permalink)  
Old March 6th, 2005, 11:59 PM
dartcoach dartcoach is offline
Friend of Wrox
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post


I've never created a table inside code. The reason I use a straight number field, is that Access keeps track of the last autonumber used and starts at the next one, even if your table has been emptied. If you create a table with no records, and after your report is done, then empty it, you are only using enough storage to store the table structure. Also, Civa's report would always begin with 1.


Reply With Quote