Query to find most recent date.

[jalge2]

I have a form on a database that keeps track of work orders. Once a week our tech comes in to fix our Scan Guns and we enter the fix date on the work order. Every Monday my boss wants to run a query to see how many guns were fixed on the most recent date. The tech doesn't come in on the same day.

Is there a way that I can build a query to just find the most recent date and pull that information?

Thanks for all the help.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[rac2]

First you find the most recent date.

SELECT MAX(date_of_service) FROM WorkOrders

Then count the number or find the number of scan-guns repaired on that date, depending on whether there is one work order for each repair or a work order shows the number repaired.

SELECT COUNT(*) FROM WorkOrders
WHERE date_of_service = (SELECT MAX(date_of_service) FROM WorkOrders)

SELECT number_repaired FROM WorkOrders
WHERE date_of_service = (SELECT MAX(date_of_service) FROM WorkOrders)