problem with VB QUery

Question

Anything wrong with the following query? subquery works fine but not the complete query :(

strNewSql1 = "SELECT tblEventLog.PartNumber & '_' & tblEventLog.PartNumberChgLvl FROM tblEventLog" & _
            "WHERE (tblEventLog.PartNumber & '_' & tblEventLog.PartNumberChgLvl) NOT IN " & _
            "(SELECT tblEventLog.PartNumber & '_' & tblEventLog.PartNumberChgLvl " & _
            "FROM tblEventLog " & _
            "WHERE tblEventLog.EventTypeSelected = 'pn REMOVED From Wrapper')" & _
            "AND tblEventLog.TrackingNumber = """ & tempTrackingNumber & """"

Fionnuala · Accepted Answer · 2011-02-07 20:03:39Z

1

You are missing a space between tblEventLog and WHERE.

"SELECT tblEventLog.PartNumber & '_' & tblEventLog.PartNumberChgLvl FROM tblEventLog" & _
        "<ADD SPACE>WHERE (tblEventLog.PartNumber & '_' & tblEventLog.PartNumberChgLvl) NOT IN " & _

answered Feb 7, 2011 at 20:03

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JohnK813 Over a year ago

And another between the end of the subquery and the final AND condition (end of the second-to-last line).

RolandTumble Over a year ago

A good practice to get into when building queries this way is to start each new concatenated line with a space: " WHERE...", Makes the spaces easier to see & harder to forget, and if you get extras it doesn't hurt anything.

Collectives™ on Stack Overflow

problem with VB QUery

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related