Recent content by DonJ

Installed today. It worked like a charm & we're heroes. I have no option but to take all the credit, though. I hope you don't mind. I hope you don't mind. DJ

Hi, Raskew's right. Obviously, you guys are light years ahead of me. You're right about the help functionality. I never tried it in 2k until tonight. I can't find a thing! Fortunately, I think you've got an answer to your predicament. THIS TIME. Good luck & best wishes, Don Jellie

Thanks to you both Good morning, First, thanks so much for the advice. It works perfectly! Second, I apologize for my misuse of syntax and my inability to see the forest for the trees. I definitely meant union and not join. It's pretty hard to help someone who can't even get his questions...

Hi Jon, I apprecate the help, but I'm afraid I need more. What I have is 2 very successful, fairly complex querieries built using Jet SQL that I need to join. I can rewrite them and use a simple join in Transact SQL with a high degree of effort, but I'd like to avoid that. Is it possible to...

I have an idea. How about setting the format in the table you've created, clearing all data, and changing your query from Make Table to Append?

Hello all, I'm trying to combine the results of 2 Access gui-created queries across the same tables using slightly different criteria. Is it possible to do this without rewriting the whole thing in SQL? I'll admit up front I can do that, but the queries are pretty complex and I'd prefer not...