How do you generate a union query into a new table but have an Autonumber Key field in the new table.
Scott Axton 18 months ago
Bill, Union queries are not editable. You can only view the data together.
If you are wanting to permanently join the two (or more) tables you would just set up your new table and append the data into the table. If you need to maintain the old id for historical purposes, just make sure you have an "OldID" field of type Number - Long Integer. You would need to run an append query to the new table.
William KennedyOP 18 months ago
Thanks Scott found that out.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.