Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT "All Parts" AS `Product Part Number`, Month(`DateReworked`) AS Mo, Year(`Datereworked`) AS Yr, Avg(tblReworkRecords.DaysToRework) AS AvgOfElapsedDays FROM (`Product part number List` INNER JOIN `Shop Order List` ON `Product part number List`.`Product Part Number` = `Shop Order List`.`Product Part Number`) INNER JOIN tblReworkRecords ON `Shop Order List`.`Shop Order Number` = tblReworkRecords.ShopOrderNumber WHERE ((Year(tblReworkRecords.Datereworked) = 2010)) AND (((tblReworkRecords.DateReworked)>'1/1/2004')) GROUP BY Month(`DateReworked`) HAVING (((Avg(tblReworkRecords.DaysToRework)) Is Not Null)) Order BY `Product Part Number`, Mo, AvgOfElapsedDays
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.