Set RS = Conn.Execute("Select top 20 antal,besokar_id,max(datum) as maxDatum, max(mem_id) as maxMem_id FROM com_besokare Where mem_id=" & Request.QueryString("id") & " group by antal,besokar_id Order by 2 desc ")
Trådstart#1
Hur ser denna sqlsträng ut i access:
Set RS = Conn.Execute("Select antal,besokar_id,max(datum) as maxDatum, max(mem_id) as maxMem_id FROM com_besokare Where mem_id=" & Request.QueryString("id") & " group by besokar_id Order by 2 desc limit 20")
