There is no LIMIT keyword in Access (if you use the JET engine). You can use TOP x to give the first x results. Usage: select Top 5 * from table_name order by column_name