Hello all. My manager wants me to create a summary report from information in 5 different tables. The main key for all tables are Status_number.
1. Requirement table - count of records
2. Defects table - count of records (if any exists)
3. Metrics - sum of two hour fields
4. Peer Review - count of records
5. Time - sum of hours worked on status (if any exists)
I could probably get a query with 3 of the tables. But I couldn't combine the Defects and Time. Obviously I need almost a merge like query where I can take 1 query, merge with maybe 2 other queries to create this super query.
But is this possible in Access 97?
Another question I had is can I use a data file as a Record Source in a report?
Thanks
1. Requirement table - count of records
2. Defects table - count of records (if any exists)
3. Metrics - sum of two hour fields
4. Peer Review - count of records
5. Time - sum of hours worked on status (if any exists)
I could probably get a query with 3 of the tables. But I couldn't combine the Defects and Time. Obviously I need almost a merge like query where I can take 1 query, merge with maybe 2 other queries to create this super query.
But is this possible in Access 97?
Another question I had is can I use a data file as a Record Source in a report?
Thanks
