Do this for all the fields except for the AutoNumber field in the Table view of the main table. From the Table Name list, select the new table that you created in step 2. Click OK. When you are prompted by the "You are about to paste row s into a new table" message, click Yes to insert the rows. On the File menu, click Close. Click No to close the AppendQuery window. Click Tables on the left pane.
Right-click the new table and then click Design View. In the Design view for the table, add an AutoNumber field with the same field name that you deleted in step 1. Add this AutoNumber field to the new table, and then save the table. Click the Create tab, and then click Query Design in the Other group. Click Add , and then click Close. On the Design tab, click Append in the Query Type group. I the Table Name list, select the new table that you created in step 2, and then click OK.
On the Design tab, click Run in the Results group. In the Design view for the table, add an AutoNumber field that has the same field name that you deleted in step 1. Access does not directly support such a mechanism wish it did.
There are some work-arounds that you can try. None are elegant. In addition, you might consider deriving a " compound key " by combining natural keys in your database.
This will work well in most cases. It will not work when you are trying to order the rows by some kind of criteria and then make a row id by that. I've tried the solutuions but am getting syntax errors or popups runtime to enter value for Rank. That field "[Row Id]" is just an example; it can be any existing column in your table or source query, as long as that column has unique values, like a row id or index.
Rownum resets the row number back to 1 when it finds that column's first row value, so that each time the query is run, rownum starts at the beginning again. This code works great unless you run the query more than once. If you do the static variable holds a value in its memory and increases the row number based on that value. For instance if you run the query and there are 30 rows, the next time you run the query its starts with Any idea how to solve this issue?
Microsoft Access always numbers AutoNumber fields beginning with the number 1. If the table has data in it already, the starting value of the autonumber will be higher than the highest value already in the table. You cannot manually edit an AutoNumber field or change its starting value.
0コメント