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.
In this article, Christopher Weber demonstrates recursive query and reporting techniques he uses to generate a tree navigation map of the database. Along the way, he builds a reusable module that uses Access graphics to draw hierarchies in reports. Read the article here
Christopher Weber takes us through a navigation map generating algorithm he uses to populate a table that describes how the forms and reports in an Access database relate to each other. This is a precursor to discussions on recursion theory in part 2 of this article.. Read the first article here