posted 13 years ago
Dear experts,
I manage to come up with the 'matching' codes.
However, it doesn't produce exactly what I want and I'm stuck so I hope someone can advise me the correct way to do the query. Thanks.
What I'm trying to achieve is:
Parents ID and contact together with the tutors name and contact and subjects taught will be displayed once a match is found.
However, I want not just perfect match. I want something like a 80% match also be displayed.
So I try to put in (Parents.strSubjectsP LIKE '%' = Member.strSubject)
So tutor that can teach the subjects that the parents want and able to teach other subjects be displayed as well, not just the 100% match.