Joining TwoTables

[spyldbrat]

Hello,



I have two tables with similar field names. The data output of both tables are the same but the field names may vary. In each table the data outputs that display are: Client, WO#, Biller, Status. I was wondering if I can somehow merge these two tables so that all Clients from both tables displays in the same column, all WO#'s display in the same column, etc - so when all is said and done, I have a total of 4 columns. Can this be done? If yes, can you tell me how? I am very beginner with Access and don't always understand the terminology so please be easy on me with your terms...

[kd2017]

Yes. You want a Union Query. Check out these links for tons of study material:

https://www.youtube.com/results?sear...ss+union+query
https://www.google.com/search?q=Access+Union+Query
https://support.office.com/en-us/art...0-ad0a75541c6e

[isladogs]

A UNION query will give you the records from both tables in one query.
However it won't merge the tables and you will still need to keep both of them.

If you want to merge them so all the data is in one table, use an APPEND query to add the records from one table to the other
It doesn't matter if the field names are different as long as the datatypes are the same for the corresponding fields in both tables
After running the APPEND query and checking the results are OK, you can then delete the second table