Report using 2 queries

[Elad Kangaroo]

I have 2 tables: One has list of projects and the billing rate for different roles (for every project different rates for different roles) and one table contain entries for hours spent per person (with his role) on a project in a specific month.

I would like to generate a report that has the total hours per role + the rates for that role (for the specific project). I created a query that sum the hours together by categories (by project) but I cant find a way to integrate the rates so they will show on the report.

Ideas??


Thanks

[June7]

Need to sum by project and role then join to table of rates.

Or build a report based on query that joins the two raw tables then use the report Grouping & Sorting with aggregate calcs in group footers. This will allow display of raw data records as well as summary calculations.

Provide sample data or even the db if you need more help because really need to know your data structure better. Follow instructions at bottom of my post.

[Elad Kangaroo]

Thanks.

I think it works.