Query Format for Count & Total Report

[ISO9000Man]

I have not had any success assembling the right queries to show the data I need for this report. Can you help me format a query or set of queries that will assemble the data in the
format I need for a report like this. The information I am using is detailed below.

Table: tblNCMRDATA

Fields involved:
Job (txt)
Type (txt)
Date (date/time)
Cause (txt)
Qty (number)
Dept (txt)
Source (txt)

Table: tblJOBINFO

Fields involved:
Customer (txt) (linked by "Job" to tblNCMRDATA)

Goal of Queries:
(1)Filter records first by Date Range, Source, Dept
(2) Assemble count & Total data for records filtered by:
(a) Parameter (Group by) (Job - Type - Cause - Customer..one at a time)
(b) Count of ea. "Source" (In - Final - Return)
(c) Total (sum) of seperate counts (In - Final - Return)

This will be accessed thru a Report showing:
[Parameter (Grouped by)] [Total] [In] [Final] [Return]

Thanks for any help you can offer
Russ