I have a page working that displays all of the records in an Access db. I want to display all but the first 2 records that have autonumber ID 1 and 2. Is there an easy way to do this?
SQL_query = "SELECT * FROM myTable WHERE ID>2"
select * from tablename where field not in (1,2)
select * from tablename where fieldname not in (1,2)
....as far as possible do not use a IN it will not be as fast as a > or < or = or something like that. With an IN a table scan will be done and is definitely slower.