By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,337 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,337 IT Pros & Developers. It's quick & easy.

Auto Number from a Make table query

P: n/a
Is there a way to assign an autonumber in a make table query? I have a main
table linked to a form and created subtables by customer from the main
table and would like to assign an autonumber to each customer subtable.
Thanks.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Kyle via AccessMonster.com" <fo***@AccessMonster.com> wrote
Is there a way to assign an autonumber in a make table query? I have a main table linked to a form and created subtables by customer from the main
table and would like to assign an autonumber to each customer subtable.
Thanks.


Using ADO, you can issue a command like:

CREATE TABLE table ( table_id AUTOINCREMENT (1000, 10), table_fld LONG)

Darryl Kerkeslager

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.