totals from multiple queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in the report that sums up the total resource hours for each
manager's team in a status report. It's generated from a staff listing table
using this:

=DSum("HoursScheduled","Staff Listing","Manager='" & [Manager] & "'")

I also have a find unmatched query to show who did not turn in a status
report for a specified date range.

So now here's what I'm trying to do:
I need the total resource hours (the code above) to subtract the hours from
the find unmatched query (code below) in relation to the manager's name.
Does that make sense?

Here's my find unmatched query:

SELECT [Staff Listing for Hours].Name, [Staff Listing for
Hours].SubDepartment, [Staff Listing for Hours].HoursScheduled
FROM [Staff Listing for Hours] LEFT JOIN [Source Query for Project Hours] ON
[Staff Listing for Hours].Name = [Source Query for Project Hours].Name
WHERE ((([Source Query for Project Hours].Name) Is Null))
ORDER BY [Staff Listing for Hours].Name, [Source Query for Project
Hours].Name;
 
Back
Top