Hi everyone i hope some one can help me, im new to this forum so if i make mistakes im sorry,
Ok i have a 2003 access database with over 3000 cars in , what i wish to do is to display the next 100 records on a daily basis that just keeps revolving, at the moment i am using the select command to show the latest records added, heres the code,any suggestions would be of a great help
<%
Dim rsLac
Set rsLac = qpConn.Execute( _
"SELECT TOP 100 " & _
"a.VehicleInStockInfoID, a.YearDesc, a.MakeDesc, a.ModelDesc, a.BodyStyleDesc, a.GearboxDesc, a.FuelDesc, a.TrimDesc, " & _
"b.Image1 " & _
"FROM tbl_Vehicle_InStock_Info a " & _
"LEFT OUTER JOIN tbl_Vehicle_InStock_Info_Images b ON b.VehicleInStockInfoID = a.VehicleInStockInfoID " & _
"ORDER BY a.VehicleInStockInfoID ASC;" _
)
i = 0
%>
Ok i have a 2003 access database with over 3000 cars in , what i wish to do is to display the next 100 records on a daily basis that just keeps revolving, at the moment i am using the select command to show the latest records added, heres the code,any suggestions would be of a great help
<%
Dim rsLac
Set rsLac = qpConn.Execute( _
"SELECT TOP 100 " & _
"a.VehicleInStockInfoID, a.YearDesc, a.MakeDesc, a.ModelDesc, a.BodyStyleDesc, a.GearboxDesc, a.FuelDesc, a.TrimDesc, " & _
"b.Image1 " & _
"FROM tbl_Vehicle_InStock_Info a " & _
"LEFT OUTER JOIN tbl_Vehicle_InStock_Info_Images b ON b.VehicleInStockInfoID = a.VehicleInStockInfoID " & _
"ORDER BY a.VehicleInStockInfoID ASC;" _
)
i = 0
%>
