SQL from access not working in VBA

[Prankster182]

Hi all, I have used the query designer in access to create the following code.

Please Login or Register  to view this content.

I am trying to use this in excel to run a query from there.

The only thing I have changed is the criteria, streamstr, division str and Date1 are all vba variables, I can't get this code to work, I have changed it a few times now and still can't get it functional,

Any help would be appreciated,

Thanks

[ranman256]

I think it may be your double-double quotes.
Try using a single quote. Access will accept single quotes around strings.

or dont use VB, save this as a query , and the quotes wont matter.

[Prankster182]

I've updated the code a bit

Please Login or Register  to view this content.

I get an Expected end of statement on the first INNER of line 2, and an Expected expression error on the first single quotation on line 3

[Kyle123]

Access gets the monk on if you don't include parentheses around your joins

[Arkadi]

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:

Please Login or Register  to view this content.

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.

[Kyle123]

I think you want:

Please Login or Register  to view this content.

[Prankster182]

Thanks, I have tried using that code and it returns a syntax error : missing operator

Here is the code as it stands at the moment.

Please Login or Register  to view this content.

[Kyle123]

You need a space at the end of each row

[Arkadi]

Or the start of the second and third... but yes there needs to be a bit of space to separate where one line ends and the next starts. Best practice is always end the line with a space, then quote