no, you need to start with a complex joined query recordset that pulls the data from all of the related tables.
the navicat tool i linked to is a good tool fro creating the recordset for you if you do not wish to learn the SQL syntax for creating such a query.