SQL Select giving Error 1

[MichHart]

Hi eveyrone:

I have this Select statement that is giving me an error

"missing ).], or item in query expression"

Here is the statement:

Set rs = db.Execute("SELECT * " & " FROM DraftDetails WHERE DraftDetails.[Player] IN (SELECT Players.[Index]" & " from Players where Players.[FirstName] = " & strFN & " and Players.[LastName] = " & strLN)

Can someone tell me what is wrong with this statement???
I am going crossed eyed!!

MichHart " Never regret yesterday because it cannot be changed;
Instead make sure today does not become a regret of tomorrow."

 

[jebry]

Hi MichHart!

You forgot to close the parentheses of the subquery:

Set rs = db.Execute("SELECT * " & " FROM DraftDetails WHERE DraftDetails.[Player] IN (SELECT Players.[Index]" & " from Players where Players.[FirstName] = " & strFN & " and Players.[LastName] = " & strLN & &quot&quot

hth
Jeff Bridgham
bridgham@purdue.edu

 

[MichHart]

Thank you so much, it was starting to drive me crazy!!! lol

Sometimes a second set of eyes is all you need!

Thanks
MichHart " Never regret yesterday because it cannot be changed;
Instead make sure today does not become a regret of tomorrow."