Latest Date Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a table that track when Caliper get calibrated and would like to create a query that will display the last date that a caliper was calibrated. How can this be don

EG
My table contains
Caliper Calibration Dat
***********************
Caliper 1 2002/10/2
Caliper 1 2003/05/0
Caliper 1 2004/02/0
Caliper 2 1998/08/0
Caliper 2 2003/08/0

and I would like to get

Caliper Calibration Dat
***********************
Caliper 1 2004/02/0
Caliper 2 2003/08/0

Thanks in advance for your help

Daniel
 
Daniel P said:
Hello,

I have a table that track when Caliper get calibrated and would like to
Click to expand...
create a query that will display the last date that a caliper was
calibrated. How can this be done
EG:
My table contains:
Caliper Calibration Date
************************
Caliper 1 2002/10/22
Caliper 1 2003/05/08
Caliper 1 2004/02/02
Caliper 2 1998/08/05
Caliper 2 2003/08/06

and I would like to get:

Caliper Calibration Date
************************
Caliper 1 2004/02/02
Caliper 2 2003/08/06

Thanks in advance for your help,

Daniel
Click to expand...

SELECT M1.Caliper
,MAX(M1.CalibrationDate)
FROM MyTable AS M1
GROUP BY M1.Caliper
 
Back
Top