Richard made his own much faster D-lookup.

Faster DLookup
Faster DLookup 2

Thanks Sami!  I remember those. I will rewatch. Thanks again sir!  Have a wonderful Friday!

How would you populate the Dictionary?

https://github.com/cristianbuse/VBA-FastDictionary

Alex, not sure haven’t tried it. I  have what I want it to do and it works but it takes a long time to process and it hangs up sometimes.  I am using queries and a record set to get the results. I give the query parameter values, one for the customer, a begin date and an end date. Those are the prompts in one of the queriies. I use that information of the customer and date range to another query that sorts through the records based on that criteria.   I asked ChatGPT  how to make it faster and it suggested using a dictionary process and gave me the code but I don’t really understand it.

My situation:
I get a csv file every morning with quotes that have been entered the day before by the customers that are assigned to me. The fields are: Quote#, Quotedate,  Customer, origzip, destzip, weight, charges.  I move them to my database using transfer spreadsheet and it works great. The issue is that there can be multiple quotes for the same information except the charges and the quote# are different. What I want to do is parse through the data and take one record with the lowest charges, and keep all the data associated with that record,  and delete the others. So, if the Quotedate, customer,  origzip, destzip, weight are the same find the lowest chargers and delete the others. The problem grouping them together is the quote# is different for every record but I only want to keep the lowest charges record with the quote#. The daily csv file has around 400 records and the table has almost 200,000. currently.

This probably does not make sense but basically I want the quote#, Quotedate, customer, origzip, destzip, weight and charges for the lowest quote for that group and delete the others records. There are usually three quotes with the same information and the only difference is the quote# and charges.

Any assistance is appreciated.

I figured it out! I was trying to make it way more complicated than it needed to be. Created two queries and it worked perfectly! Not all for naught though, learned some things in the process. Thanks for the assistance. On to the next solution!!