Hi, I see a number of problems here, first of all your string is all broken up... you need to close each line with a " and then & _ in order to be able to build a string on multiple lines, so it would look like:
but additionally you seem to be trying to do an inner join between two inner joins? The syntax seems off to me, but since I don't have the database I can't really play around with it. I might suggest building 2 queries in access to perform the two sides of the inner joins, then you can use excel to run the inner join between those two.
Bookmarks