LIKE problems in a query

[Jeff]

My two fields are:

[Participation ACE Convert Query].Program = "CITY"
Outings.ProgramID = "ACE/CITY/OASIS/Upper"

and the SQL in the query looks like:

ON ([Participation ACE Convert Query].Program Like "*" &
Outings.ProgramID & "*")

But I'm not getting a match based on this code. Could someone help me?

Thanks!

Jeff

 

[John Spencer]

You are comparing in the wrong direction.

ON ([Participation ACE Convert Query].Program Like "*" &
Outings.ProgramID & "*")

Should be

ON (Outings.ProgramID Like "*" &
[Participation ACE Convert Query].Program & "*")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Marshall Barton]

My two fields are:

[Participation ACE Convert Query].Program = "CITY"
Outings.ProgramID = "ACE/CITY/OASIS/Upper"

and the SQL in the query looks like:

ON ([Participation ACE Convert Query].Program Like "*" &
Outings.ProgramID & "*")

But I'm not getting a match based on this code. Could someone help me?

You have them backwards

ON Outings.ProgramID Like "*" &
[Participation ACE Convert Query].Program & "*")

 

[Jeff]

You have them backwards

ON Outings.ProgramID Like "*" &
[Participation ACE Convert Query].Program & "*")

Geez, thanks... I'll blame it on the early hour on a Saturday!