Search results

I have an Access database that links one form to one table, so a fairly simple database. The database will average 250k records. How do I query to pull up many (ex. 100) distinct records. Example - I want to search in a field called 'debtornumber' and want to pull up lots of various account...