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")
2 svar · 213 visningar · startad av Asa
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")
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 ")
Tackar :)