Consolidating data in access
You will still need to add the -1 to the criteria of the billing and "Active" to the status criteria.
I'm trying to aggregate some instructor data (to easily show which courses an instructor taught in a semester), and up until now I've just accepted having multiple rows for each instructor.
A special command called an Append query automates the task by selecting data from one table and copying it to another quickly.
You even have the ability to choose the records you'd like to copy from your source table and append in the destination table.
Click "Create" and then click "Query Design" to view the Show Table window that lists the database's tables.
Click the table that contains the records you wish to copy.
You also use joins to combine records from both data sources, so that each pair of records from the sources becomes one record in the query results.For instance, if the first field in the source table is a number field, the first field in the destination table must be a number field.As Microsoft notes, "Text fields are compatible with most other types of fields." In other words, it's okay if a field in the source table is a number field and the corresponding field in the destination table is a text field.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.In this example will be only concerned with Table and Queries. 5a) Select tbl_Customer from the Show Table Window. Do this for all the fields you will need for both tables.