Tuesday, June 14, 2011

Reporting from Two Tables with Common Data

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.

No comments: