If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access: How can I generate an auto number for each record in a ta.
I have a make table query and wish to number the records generated with an
autonumber field. The query is based on filtered results from another table, when I tried adding a count function to the field I wish to record the autonumber in Access responded indicating the field would not be valid based on the fact that criteria is defined in another field of the query. Any ideas? |
#2
|
|||
|
|||
First, if you can generate the records with a query, are you certain you
need a table? Second, instead of a Make Table query, another approach would be to define the new table (running Make Table once can help, but you'll want to go in and modify it, at least to include the Autonumber), then use Delete and Append queries to re-load it. Finally, the Access Autonumber is designed for use as a unique row identifier. Since you are creating these new records, unless you are planning to subsequently refer to the rows in other tables, you might not need an Autonumber/primary key (oops?! you didn't say you were trying to create a primary key -- are you?). Good luck Jeff Boyce Access MVP "TerryGB" wrote in message ... I have a make table query and wish to number the records generated with an autonumber field. The query is based on filtered results from another table, when I tried adding a count function to the field I wish to record the autonumber in Access responded indicating the field would not be valid based on the fact that criteria is defined in another field of the query. Any ideas? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto Number field--starting number? | pcteacher | General Discussion | 1 | October 19th, 2004 10:46 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
Excel 2002 "auto" number format | Norman Harker | Worksheet Functions | 0 | February 26th, 2004 04:40 AM |
Auto form number | Freshman | Worksheet Functions | 1 | November 13th, 2003 09:12 AM |