Combining Tables

[Guest]

How do I take two tables and combine them together to make one?

Its three columns of data, same type.

Thanks in advance

 

[Rick B]

If you are doing this as a permanent task, then just build an append query
and append all records from tableA to tableB, then delete tableA.

This is what you should do. It is not "normalized" to have two identical
tables. This normally happens when someone fairly new to Access tries to
store similar records in different tables so they can differentiate
different "types" of records. For example, some users might store A/P
vendors in one table, and A/R vendors in a separate (yet identical) table.
This is not proper design. Instead, they could simply add a "VendorType"
field and define the records as one or the other.

If you insist on keeping your current structure (or if there is a good
reason for it), then you can create a UNION query to pull all records from
two separate tables. You can then use that UNION query as the source for
your reports or forms.

 

[Guest]

Thank you much

If you are doing this as a permanent task, then just build an append query
and append all records from tableA to tableB, then delete tableA.

This is what you should do. It is not "normalized" to have two identical
tables. This normally happens when someone fairly new to Access tries to
store similar records in different tables so they can differentiate
different "types" of records. For example, some users might store A/P
vendors in one table, and A/R vendors in a separate (yet identical) table.
This is not proper design. Instead, they could simply add a "VendorType"
field and define the records as one or the other.

If you insist on keeping your current structure (or if there is a good
reason for it), then you can create a UNION query to pull all records from
two separate tables. You can then use that UNION query as the source for
your reports or forms.