A SQL statement

[Anon]

I have to search thru a table consisting of over 15,000 rows of entries using MS Access. I was wondering if there was anyway to limit the resulting rows. I kno with mysql, u can just go ahead and do this:

SELECT * FROM db WHERE blah='blah' LIMIT 100

... and there will be 100 or less results...
some guy told me to do SELECT TOP 100 FROM ... but that obviously isn't correct...
what is the equivalent with MS Access?

[Anon]

select top 100 etc. has worked for me in access 95+ and mssql. You say it obviously isn't correct. What problem did you have when you tried using that syntax?