I am trying to open a report from a form using data from a field on the form as the criteria for the report query. I will try to explain.
I can get the report to open when the form field reads a single criteria like "Cross Country". My problem comes when I try to get the report to open when the field says Varsity Soccer or JV Soccer. If I put *soccer* directly in the query criteria the report opens. If I put *soccer* in the form field and then get the query to read the criteria from the form, the report will not open. I have also tried "Varsity soccer or JV soccer" in the field and it still does not work.
What other wording can I use to get all the Varsity soccer and JV soccer names to open in the report? Or what other approach should I use?
See attached sample database.