 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / August 2006date query
I have a table with the following data: [Upgrade date] [Ticket Number] [Agent Opened Date] 2/12/2006 235556 5/18/2006 I need to trend the tickets opened weekly for a 30 day period prior to the upgrade date. I am currently showing only [Ticket Number] Where [Agent Opened Date] >=[Upgrade date] Can not figure out how to then trend the output. Thank you! Is this what you are looking for? SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket Number] FROM naulerich GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade date],"ww"),2); > I have a table with the following data: > [quoted text clipped - 7 lines] > > Thank you! Thank you Karl, but I am lost...can I send the current sql for your review? I am not sure how to incorporate the statement below. Thanks! :) > Is this what you are looking for? > [quoted text clipped - 16 lines] > > > > Thank you! Post it. > Thank you Karl, but I am lost...can I send the current sql for your review? > I am not sure how to incorporate the statement below. [quoted text clipped - 21 lines] > > > > > > Thank you! SELECT Quality_Affected_Cust.[CR Reported Date], Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #], Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name], Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary], Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR Substatus], Quality_Affected_Cust.[Description/How to Reproduce], Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary Function], Quality_Affected_Cust.[Product Line], Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project], [xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date] FROM Quality_Affected_Cust INNER JOIN [xBeta Project Table] ON Quality_Affected_Cust.[Global Id] = [xBeta Project Table].[Global ID] GROUP BY Quality_Affected_Cust.[CR Reported Date], Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #], Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name], Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary], Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR Substatus], Quality_Affected_Cust.[Description/How to Reproduce], Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary Function], Quality_Affected_Cust.[Product Line], Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project], [xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date], Quality_Affected_Cust.[CR Reported Date] HAVING (((Quality_Affected_Cust.[CR Reported Date])>=[Upgrade Date]) AND ((Quality_Affected_Cust.Product)<>"Demo Media")); > Post it. > [quoted text clipped - 23 lines] > > > > > > > > Thank you! [CR #]=[Ticket Number] in the example first posted. > SELECT Quality_Affected_Cust.[CR Reported Date], > Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #], [quoted text clipped - 53 lines] > > > > > > > > > > Thank you! Now I am lost as the SQL you post has only one field that matches your orignal post. I thought you did not understand the SQL I gave to you as a solution to your orignal post. > [CR #]=[Ticket Number] in the example first posted. > [quoted text clipped - 55 lines] > > > > > > > > > > > > Thank you! Sorry for the confusion here is what I am trying to do: [Upgrade date] [CR #] [CR Reported Data] 2/12/2006 235556 5/18/2006 Trend the [CR #] weekly for a period of time 30 days prior to the [Upgrade Date] Thank you! :) > Now I am lost as the SQL you post has only one field that matches your > orignal post. [quoted text clipped - 61 lines] > > > > > > > > > > > > > > Thank you! Karl, Do you have enough info to help me incorrporate the statement that you created? Thank you! :) > Now I am lost as the SQL you post has only one field that matches your > orignal post. [quoted text clipped - 61 lines] > > > > > > > > > > > > > > Thank you! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.