It is good to refer to the relationship tool when looking at reports to remind us what tables are connected to others. A report might fail if you select tables that are very far apart in this diagram and they are connected by more than two joins. If you want to do reports where the tables are quiet spread from each other it is better to do a query to get the data and then create the report. Use grouping when using the report wizard.
Free Database Tutorials From VTC:
Access 2010
Access 2007
Access 2003
Access 2002
Access 2000
Access 97
Database Optimization
Data Modeling
Visual Basic for Access
For more free database, programming or software tutorials click here and do a search or click one of the categories.
