Consolidating data in access
Microsoft Access 2013 databases consist of tables that you can change in a variety of useful ways.For example, if your database contains two similar tables, you don't have to spend ages copying data manually to merge them.If you know that you will have duplicate rows in your data and you want to keep them, you’ll need to use UNION ALL.UNION ALL will allow the duplicate rows to come through.Open an Access database that contains a table you want to merge into another table.
You even have the ability to choose the records you'd like to copy from your source table and append in the destination table.Create a new table that have all the columne in all your 5 tables, then create the needed SQL statment like SELECT * FROM Tb1 INTO Table With All Columns eventually add some WHERE to exclude the duplicate rows from the insert.This will work if your table doesent have similar rows.You will still need to add the -1 to the criteria of the billing and "Active" to the status criteria. Step 1: Create links to your Excel workbooks in Access.
Search for consolidating data in access:
How to create a data source from two Access tables In the Access Database are objects called Tables, Queries, Forms, etc. The Query Window now has the two tables in it and is ready for the individual fields to be moved into the design grid. 7) Right click on the selected field and while holding down the mouse button, drag the field to an empty grid.