I am looking to query a dataset of mine in MS Access 2016 where only specific strings are included within the query's output (please take a look at the included image). I am looking to include all fields with strings that contain the word "rat", "mouse", "stoat", and "possum" from the "Pest_com" columns while all other fields within those columns are excluded.
Normally I would have used a left join from the parent table with subsequent operators, but I am looking to keep all records of the table. Setting up a query in this manner seems to filter out records that do not include the strings I am looking for. Instead, I want to keep all records within the query and just remove the fields that do not contain my desired info.
Thanks in advance for your help!