Hi,

I try to select data from my database where i will pull the data based on latest time and group by name.

below are the sample data:

ID   Name    Starttime                       Endtime

1    AAA        1/5/2012 8.00am           1/5/2012 10.00a.m

2    BBB          2/5/2012 9.00a.m

3    CCC          2/5/2012 10.00a.m       2/5/2012 3.00pm

4    AAA          2/5/2012  10.00a.m

select ID, Name, Max(Start_Time), End_Time from chamber group by Name

System will return me data as below:

ID   Name       Starttime                       Endtime

2    BBB          2/5/2012 9.00a.m

3    CCC          2/5/2012 10.00a.m       2/5/2012 3.00pm

4    AAA          2/5/2012  10.00a.m      1/5/2012 10.00a.m

System will automatic replace the empty value on End_Time on 'AAA'

Can someone help me to fix the error.

Thanks