Query using Like criteria pattern matching

[vad77]

I have a query built that will produce results on user input for two fields, System and StationName.
In the criteria I have the following.

Like "*" & [Enter CIC System] & "*"
Like "*" & [Enter Station Criteria:] & "*"

I have 3 systems with two having similar names



SysA
SysB
Non-SysB

If I enter SysB in the for system criteria my results will include Non-SysB.
What do I need as the criteria that when SysB is entered is does not in clude Non-SysB in the results.

Hope I am clear In what I am asking.
Thanks in advance.

[June7]

AND NOT [fieldname] LIKE "Non*"

Or maybe don't use the first * wildcard. Does user type "A" or "B" or "SysB"?

I never use dynamic parameterized query - cannot validate user input. I prefer VBA to build filter criteria and apply to form or report. Review http://allenbrowne.com/ser-62.html

[vad77]

Thanks for you reply, again over thought things. Turned something simple to complicated. Just removed the wild cards from system. Need to get back to the office staying home is taking a toll. Thanks for the help.