Combining 2 types of criteria to match reports

[Kckronic21]

I am having a problem with setting up my query. In my query I have fields such as last name, first name, and school. Under the school field, I have been putting in the following criteria: [Forms]![School_Form]![SchoolNametxtbox]. I have been running both my query and my report through the School form. Now I have people that go to more than one school. For Example, In my table I have them listed as Angel Oak/Lambs. My question is how to I set up a query to run through the form like I have been doing before and to also retrieve those that attend more than one school.

 

[JoeMiller]

You can change the criteria in your report to something like this:

Like "*" & [Forms]![MyForm]![MyControl] & "*"

Then when you select a school, access will look to match the string in the combo box and any other characters to the left or right (ie: another school).

HTH Joe Miller
joe.miller@flotech.net