Search results

I can make it work like this. Thanks so much for ALL of your help!!!

Yes, it lists it once in the table, but it does not pick up all records, it only pulls one...

Nigel, The query works very well with one exception and I can't figure out how to correct it. When the query runs it does pull all of the debtor numbers I am looking for, but it does a distinct find for the debtor numbers. Usually, the same debtor number is in my databases 3-4 times and I need...

Nigel, It looks like this will work! I will test this week with live data and let you know if I have any questions. Many, many thanks!!

Attached with dummy data and took everything out of the database that wasn't relevant (tables, queries, reports, etc.).

Mihail - do you have an email I could send to you directly?

Sorry, yes, the data type is text, not a number.

I have debtornumber set as PLAIN TEXT because when I tried to establish debtornumber as a number, it drops the leading zero and I need to keep that in the debtornumber field.

Mihail, YES, correct. Can you explain how I go about it please?

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...