This month, Peter Vogel looks at reporting from two tables where one table overrides entries in the other table.
Here is the problem: I have a master table of data that I want to report on. However, I also have a table of daily data. Where there’s a matching record in the daily table for a record in the master table, I want to use the daily table’s record. Read the article for the solution.