MS Access - Five and Seven day queries

B

Beeyen

Good Day Experts

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top