I created two tables for this tutorial, a Customer table which stores customer an and Order table which stores orders. The Order table is empty and contains a customer_id field.
The best way to handle this type of event, the updating of many records in a database table, is to use an Update Query to make the changes to data in one operation.
Queries can be difficult to understand and build if you don't have a good idea of what you're trying to find and how to find it.
A one-table query can be simple enough to make up as you go along, This process might seem abstract at first, but as we go through the process of planning our own multi-table query you should start to understand how planning your queries can make building them a lot easier.
I have two identical Access tables, for example tbl Data Yesterday and tbl Data Today. It is based on data changes at the field level and not the record level. HTH No, I'm sorry, it is not a regular outer join query that I need.
The data from tbl Data Today has updated data changes in it that are different from tbl Data Yesterday. I want to compare the two tables and display in a query the differences between the data from both tables. For example, in tbl Data Yesterday a field called Part Number may be 1234 and in tbl Data Today the field Part Number has been changed to 5678. It is based on data changes at the field level and not the record level.