PC Review


Reply
Thread Tools Rate Thread

Access Query - returns 5 and 7 day information

 
 
Beeyen
Guest
Posts: n/a
 
      1st May 2010
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)

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query in VB access returns less records than via DAO ? Acie Microsoft Access Queries 7 21st Aug 2008 06:45 PM
Select query returns a different result in Access and Access-VBA Konrad Hammerer Microsoft Access 7 10th Jun 2007 01:43 PM
query returns rows from access but not from .Net =?Utf-8?B?S3N0cm8=?= Microsoft Access 4 13th Mar 2006 12:06 PM
VBA Query returns incorrect information in replicated database =?Utf-8?B?Q29yb3Zlc3Npcw==?= Microsoft Access Form Coding 0 22nd Jun 2005 04:31 PM
Sql query from Access returns no records, but SQL Query Analyser d =?Utf-8?B?TWlrZUIgaW4gV0I=?= Microsoft Access Queries 0 14th Dec 2004 03:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 PM.