This should help you transistion your MS Access to SQL Database

Hope this helps...

Please check this sample...

create table #temp (num int, cname varchar(50), dt smalldatetime)

insert #temp select 123, 'a', '2-3-2010 12:35:29'

insert #temp select 123, 'a', '12-4-2010 12:35:29'

select num, cname, max(dt) from #temp group...