combine tables into 1 table

[Glenn]

I have two different tables, which I need to keep separate.

These two tables contain the exact same fields.

Is there a way to create some type of query so that I can come up with one
combined table?

Thanks.

 

[Rick B]

A union query will let you pull data from two or more tables to one query.
BUT, I would recommend you combine these into one table, not keep them as
two. You should add a field to differentiate the data. If table 1 is
employees and table 2 is supervisors, for example, then add a "title" field.
I you have a table for males, and an identical table for females, add a
"gender" field.

It is very rare that you should have two identical tables. This is not good
"normalized" database design.

 

[Pieter Wijnen]

To elaborate, If it's for security reasons
"Split" the table using two seperate Queries & use the WITH OWNERACCESS
OPTION Clause (Properties: Run Permissions)

HTH
Pieter