math functions in a query

J

JohnLute

I have a real challenge.

Two queries:

qryCompsFacs:
SELECT tblComplaints.DateReceived, tblComplaints.ProductionFacility
FROM tblFacilities INNER JOIN tblComplaints ON tblFacilities.txtFacilityID =
tblComplaints.ProductionFacility
WHERE (((tblComplaints.DateReceived) Between
[Forms]![frmComplaintQueriesReports]![BeginningDate] And
[Forms]![frmComplaintQueriesReports]![EndingDate]) AND
((tblComplaints.ProductionFacility)=[Forms]![frmComplaintQueriesReports]![cbFacility]))
OR (((tblComplaints.DateReceived) Between
[Forms]![frmComplaintQueriesReports]![BeginningDate] And
[Forms]![frmComplaintQueriesReports]![EndingDate]) AND
(([Forms]![frmComplaintQueriesReports]![cbFacility]) Is Null));

qryFacsCasesProduced:
SELECT tblFacilitiesCasesProduced.txtFacilityID,
Sum(tblFacilitiesCasesProduced.TotalCasesProduced) AS SumOfTotalCasesProduced
FROM tblFacilitiesCasesProduced
GROUP BY tblFacilitiesCasesProduced.txtFacilityID;

Now for the question:
How can I divide
[qryFacsCasesProduced].[Sum(tblFacilitiesCasesProduced.TotalCasesProduced) AS
SumOfTotalCasesProduced] by 100,000 and then divide that result by the total
number of records as filtered in [qryCompsFacs].[ProductionFacility]?

This one really has my head spinning! Anyone up to the challenge? I'd
appreciate any advice - THANKS!
 
K

KARL DEWEY

Use your first two queries as input for a third query where you do the math.
 
Top