here may be babblers, wholly ignorant of mathematics, who dare to condemn my hypothesis, upon the authority of some part of the Bible twisted to suit their purpose. I value them not, and scorn their unfounded judgment.
How do you generate a union query into a new table but have an Autonumber Key field in the new table.
Scott Axton 6 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 Kennedy 6 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.