ApplyFilter for multiple criteria

[joltremari70]

I am trying to figure out how to use the applyfilter in a macro to return records based on 1 criteria from 2 different fields. So that I can enter "John" as the filter criteria and it would return the records for William John and John Mitchell, even though the values are stored in "LastName" and "FirstName" fields. When I use 'And' it returns nothing, when I use 'Or' it returns only one.

Any thoughts...

 

[fvdb]

Make an combined field from firstname & lastname in your query and search then on that field