Recent content by NauticalGent

Ramones and The Clash are my go-to when I need to "get my head right". Went on a ska kick for a little while too.... Welcome to AWF!

Welcome, Scottish Brian!

Building on what MajP had shared, you may find this helpful:

Just in case anyone wanted to play with both methods, here is the db I played around with. Appreciate the lesson today!

I just tried the Cartesian join theory and it took only about 3 min. Of course I didn't believe it and ran it again and it took even less time. I would have bet GOOD money against a "bad" query outperforming clean VBA - and would have lost every penny. THIS is why I will never be as cool as...

Also, the time it took as about 943 seconds or 16 min. If anyone was access to SQL server, I would be interested to see how long it would take...

Disclaimer, I had to use AI to generate the code I got work. But I thought it would make a good thread anyway. I have a 5 digit code that I use a lot in my line of work. It's called a Commercial And Government Entity (CAGE) code and the Master file on the DoD website holds over 3 million...

Amen, amen and amen

Welcome aboard!

Redstick, You have instinctively grasped what a lot of other visitors to this forum hasn't. The experts that help out here do not do it for money or glory - they do it because they value Access and want to help others get to where they are. Their time is valuable and you have demonstrated that...

Tony, I don't care what the others say about you, you're 'purt near :cool:...

yes...?

Like a few folks we know and love here at AWF!

Same

(y) (y) (y)