Joining two fields in access that are not exactly alike!!

[aarondewberry]

Hi. I have two tables, table1 has a field called WEEKDAY, within that field is say a row containing the text "WED". Table2 has many fields but also has a field called WEEKDAY. But within this WEEKDAY field it might have a row containing the text "MON, TUE, WED" on one row.
What I want to do is match [table1]![WEEKDAY] to [table2]![WEEKDAY] but I want it to show the row that contains "MON, TUE, WED" aswell as all the rows that just contain "WED".
Makes sense? Can this be done?

 

[PHV]

WHERE table2.[WEEKDAY] Like '*' & table1.[WEEKDAY] & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886