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

Its three columns of data, same type.

Thanks in advance

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.


--
Rick B



"MSHO" <(E-Mail Removed)> wrote in message
news:0AAE1388-A6B1-4671-B1DA-(E-Mail Removed)...
> How do I take two tables and combine them together to make one?
>
> Its three columns of data, same type.
>
> Thanks in advance

Thank you much

"Rick B" wrote:

> 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.
>
>
> --
> Rick B
>
>
>
> "MSHO" <(E-Mail Removed)> wrote in message
> news:0AAE1388-A6B1-4671-B1DA-(E-Mail Removed)...
> > How do I take two tables and combine them together to make one?
> >
> > Its three columns of data, same type.
> >
> > Thanks in advance
>
>
>