Prev: MS Access - Five and Seven day queries
Next: multiple query criteria
From: Beeyen on 30 Apr 2010 22:46
Good Day

Situation:

I have a query in which I am trying to create to address the following data
in my table. The coding is created in two parts

Changes completed (qryTask):

SELECT [tblWorkload Information Tracker].ProductionAssigned, [tblWorkload
Information Tracker].DatatrakNumber, [tblWorkload Information
Tracker].DateReceived, [tblWorkload Information Tracker].WorkType,
[tblWorkload Information Tracker].WorkCategory, [tblWorkload Information
Tracker].EffectiveDate, [tblWorkload Information Tracker].QandALead,
[tblWorkload Information Tracker].QAComplete, (IsNull([QAComplete])+1) AS
Done, ([QAComplete]-[DateReceived]) AS Elapsed
FROM [tblWorkload Information Tracker]
WHERE ((([tblWorkload Information Tracker].QAComplete) Between [Beginning
Date] And [Ending Date]));

Changes completed in 5 and 7 days: qryTaskInterval

SELECT [tblWorkload Information Tracker].ProductionAssigned AS Expr1,
[tblWorkload Information Tracker].DatatrakNumber AS Expr2, [tblWorkload
Information Tracker].DateReceived AS Expr3, [tblWorkload Information
Tracker].WorkType AS Expr4, [tblWorkload Information Tracker].WorkCategory AS
Expr5, [tblWorkload Information Tracker].EffectiveDate AS Expr6, [tblWorkload
Information Tracker].QandALead AS Expr7, [tblWorkload Information
Tracker].QAComplete AS Expr8, [Elapsed] AS Expr10, IIf([Elapsed]<=5,1,0) AS
5_Day, IIf([Elapsed]<=7,1,0) AS 7_Day
FROM [tblWorkload Information Tracker]
WHERE ((([tblWorkload Information Tracker].QAComplete) Between [Beginning
Date] And [Ending Date]));

Desired Results:

What I would like assistance with is combining the two queries with no
duplicates and how to include:
The total number of entries completed'
The total number of entries = 5 days and percent to the total completed'
The total number of entries = 7 days and percent to the total completed'
How to exclude holidays and weekends

Any assistance you can provide would be much appreciated. (db included)

 | 
Pages: 1
Prev: MS Access - Five and Seven day queries
Next: multiple query criteria