I've added a table to the Db and reconfigured the Recordset LEFT JOINs, and also the Wizard to add in the additional columns. However, when I exit the Wizard, it tells me to be sure that what's supposed to be in the AND is not in the OR, and won't let me go further.
When I switch these around, I can close the Wizard, but the search no longer works properly.
I tried pasting in the above code to get it to work again, but on opening the Wizard it now says I have a syntax error and all editing must be made through the Wizard.
The search finds the new table, but not 'green grease' which was the original issue. Since you fixed the issue, I don't know how to get back where we were without running into the Wizard error message.