0

This is the relevant SQL:

    strSQL_SRC = "SELECT tblGroupEmailType.GroupEmailTypeID, tblGroupEmailType.GroupID, " _
                    & "full_PGAL_Sth_Master.[Office-Email], " _
                    & "ztNumOfOfficeEmailAddrsForGroupID.[# of Office Email Addr] " _
                    & "FROM full_PGAL_Sth_Master " _
                            & "INNER JOIN tblGroupEmailType " _
                            & "ON full_PGAL_Sth_Master.GroupID = tblGroupEmailType.GroupID " _
                            & "INNER JOIN ztNumOfOfficeEmailAddrsForGroupID " _
                            & "ON tblGroupEmailType.GroupID = ztNumOfOfficeEmailAddrsForGroupID.GroupID " _
                    & "WHERE tblGroupEmailType.GroupID = " & lngGroupID

When I get to the line where the recordset is opened based upon the above SQL, I receive the following error message:

Err.Number: -2147217900 Err.Descr: Syntax error (missing operator) in query expression 'full_PGAL_Sth_Master.GroupID = tblGroupEmailType.GroupID INNER JOIN ztNumOfOfficeEmailAddrsForGroupID ON tblGroupEmailType.GroupID = ztNumOfOfficeEmailAddrsForGroupID.GroupI'.

I looked very carefully at the code and I cannot spot anything.

I also created a query with the same tables, relationships and fields being returned. I supplied a specific number for the variable lngGroupID and that worked fine.

Maybe there is a missing space or something, but I can't see anything.

Improve this question
3
Related questions
0
syntax error (missing operator) in query expression - VBA and Access
2
SQL VBA Run-Time Error 3075: Syntax error(missing operator) in query expression
0
SQL query - syntax error (missing operator) in query expression
Load 3 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.