Combining fields (Union?)

[Guest]

I have 4 tables in a database (Accounts, Shares, Loans and Certificates). My
accounts table includes every account. My shares table has only information
about my share accounts. My loans table has only information about my loan
accounts, etc. I need to create one table that lists every account and takes
the detailed information (such as balance) from the share, loan or cert table
and matches it up on one field so that I can see all balances for all
accounts in just two columns.

The share, loan and cert tables all contain the same detail fields. How can
I take balance, for example, from my share, loan and cert tables and create
it as one field in a query and place it next to the respective account number
from the accounts table?

 

[Guest]

Create a table that contains the fields used in all of the separate tables.
Add a field that identifies the type of account. Run an append query with
added output field like ABC:"A" for Accounts. The append query for Shares
would have "S" for output in that field.

 

[Guest]

You don't say whether the tables are used for other functions which I am
assuming they are. In which case you want to maintain their individuality.
Perhaps what you want is to create a Union Query that combines data from all
the tables.