SQL IN does not work

  • Thread starter Thread starter Fritz Haubrich via AccessMonster.com
  • Start date Start date
F

Fritz Haubrich via AccessMonster.com

Hello,

I need help: Why does this not work?

SELECT *
FROM Speakers, Talks
WHERE (((Speakers.SpkID)=72) AND ((Trim([Talks].[TalkNr])) In ([Speakers].[ListOfTalks])));

TalkNr is an Integer, ListOfTalks a string containing f.i. "3,5,8,56,78"

Is there a workaround?

Thanks in advance.
 
Hi,


You have a problem of syntax.

"32" is not in ("1,32,33")

but in ("1", "32", "33")


It could be a better idea to have ONE value per field, and then



SELECT *
FROM Speakers INNER JOIN Talks
ON Talks.TalkNr = Speakers.Talk
WHERE Speakers.SpkID=72





Hoping it may help,
Vanderghast, Access MVP
 
Back
Top