OK, I've got one for you....
 
Using SQL, how can you limit the number of records returned by a query, the way you would use "recno()" in FoxPro. Say, for example, I only want to pull the first 500 records that meet a certain criteria....
 
Reply to all with answers, please.
 
Thanks,