vba-excel
vba-excel
Pull request to correct issue #32
Sorry for the late reply. To give you a proper example, suppose u have 4 Tables like the example below:  The query I am trying to build is to...
Just edited my previous post. Think i Had a issue with "Copy and Paste" cause both code snippets were not supposed to be the same... I don't have a older...
OK .. i edited the posts once more .. and corrected it again. Thats what the code snippet that i used and what i get from `Debug.Print MySelect.iSQLQuery_ToString` is the...
> I don’t see where a problem would be. The parenthesis are optional, so that shouldn’t cause a problem. Can you try using table aliases instead of leaving them as...
> Ahh! In MS Access, parenthesis are not optional. > > I think the fix will be: if number of joins is greater than two, for all joins except the...
> Ahh! In MS Access, parenthesis are not optional. > > I think the fix will be: if number of joins is greater than two, for all joins except the...
Think this should do the trick. I havent tested it.. Im on mobile phone atm File: SQLSelect.cls Modified function JoinString() Code snippet untested ``` Private Function JoinString() Dim R As...
> Thanks! If you’ve made a change to the code in the library and want to submit a pull request, go ahead. As you suggested, created a pull request with...