Interesting.  I've been a DBA with "other related duties" most of my career. It always involves loading some data, cleaning it, etc. but usually I can avoid typing much of...

Thanks. I tried it. Nice.  Do you have some sample data for main_query?  I tried some test values and nothing I am coming up with causes any of the men...

Thanks pietlinden!  I will use these resources and if I get it all done maybe I can post what I did in case anyone else is searching for this.

Thanks pietlinden. I recognize your name and I think you've helped me before a long time ago.  I'm afraid I don't know how to program Access.  The same tables will...

Thank Lynn Pettis,
I didn't even think of the formatting though I do sometimes take the part of the code that's causing errors and put in on a separate line....

Great. Thanks very much.

Thanks sgmunson. I think what I'll do to make my question much easier to answer is build a quick-and-ugly .NET webpage to show the problem I'm having in thinking...