Here is the SQL Code
SELECT ev.evDate, evDet.bandID, ev.LocID, ev.cltID, ev.[more info], ev.Type
FROM locInfo INNER JOIN (bdInfo RIGHT JOIN (ev INNER JOIN evDet ON ev.evID = evDet.evID) ON bdInfo.bdnfoID = evDet.bandID) ON locInfo.locInfoID = ev.LocID
WHERE (((InStr([Enter Multi-Bands sep by comma],[bdinfo]![name]))>0 Or (InStr([Enter Multi-Bands sep by comma],[bdinfo]![name])) Is Null))
ORDER BY ev.evDate, evDet.bandID, ev.Type;
Query works great with one exception. There is a Band named "Electric Avenue" and a Band Named "Avenue". Anytime "Electric Avenue" is used - results for "Avenue" show up.
However, If "Avenue" is used - results for "Electric Avenue" do not show up. (the desired result)
Is there a way to set the InStr to be an exact match?
SELECT ev.evDate, evDet.bandID, ev.LocID, ev.cltID, ev.[more info], ev.Type
FROM locInfo INNER JOIN (bdInfo RIGHT JOIN (ev INNER JOIN evDet ON ev.evID = evDet.evID) ON bdInfo.bdnfoID = evDet.bandID) ON locInfo.locInfoID = ev.LocID
WHERE (((InStr([Enter Multi-Bands sep by comma],[bdinfo]![name]))>0 Or (InStr([Enter Multi-Bands sep by comma],[bdinfo]![name])) Is Null))
ORDER BY ev.evDate, evDet.bandID, ev.Type;
Query works great with one exception. There is a Band named "Electric Avenue" and a Band Named "Avenue". Anytime "Electric Avenue" is used - results for "Avenue" show up.
However, If "Avenue" is used - results for "Electric Avenue" do not show up. (the desired result)
Is there a way to set the InStr to be an exact match?