% set rs=cn.execute("SELECT * FROM tblNews ORDER BY NewsDate DESC") set rs2=cn.execute("SELECT * FROM tblNews ORDER BY NewsDate DESC") rs2.movenext set rsFE=cn.execute("SELECT * FROM tblEvents WHERE EventDate>=#" & date() & "# ORDER BY EventDate") set rsPE=cn.execute("SELECT * FROM tblEvents WHERE EventDate<#" & date() & "# ORDER BY EventDate") %>
|