Data from two tables

[JOUIOUI]

I have two tables, one titled CCPmtA and CCPmtB. Each table has the same
column headings. I only want to incorporate the following columns from each
table into a query or another table for a report I want to create. The
columns I need from each table are: PmtType, Amount, TableID. What is the
best way for me to combine this information so I can create a report with
this column information. I haven’t worked with Access in about 2 years and
am a little bit rusty, I appreciate your help, thank you.

 

[Allen Browne]

You can combine the data from 2 tables into one long list with a UNION
query.

Access can't show this kind of query graphically, so you will have to type
it in. Additionally, UNION queries are read only (okay for your report, but
not editable in a form.)

1.Create a new query.

2. Switch to SQL View (View menu.)

3. Enter something like this:
SELECT PmtType, Amount, TableID
FROM CCPmtA
UNION ALL
SELECT PmtType, Amount, TableID
FROM CCPmtA;

Long term, the better solution might be to combine the 2 tables into one,
with an extra field to indicate whatever is the difference between the 2.