Filter Report from Query

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I am trying to filter a report based on a query. I have it working so
far as it goes. I've used a Like statement to filter my report. My
problem now is that the field on which I'm filtering contains people's
first names, and some rows contain multiple names (like "Karen/Rick").
My current query will only find the instances of "Rick" where his name
exists by itself. How do I get it to find any instance where the
filtered field CONTAINS the value I want?

Thanks!
Sarah
 
I am trying to filter a report based on a query. I have it working so
far as it goes. I've used a Like statement to filter my report. My
problem now is that the field on which I'm filtering contains people's
first names, and some rows contain multiple names (like "Karen/Rick").
My current query will only find the instances of "Rick" where his name
exists by itself. How do I get it to find any instance where the
filtered field CONTAINS the value I want?

Thanks!
Sarah
Click to expand...

Like "*" & [What Name] & "*"
 
Back
Top