Stored flexible filtercriteria in a table (novice)

[MarcelMegens]

I have 2 tables: 1 with 3 columns (Partnumber,Types and Functions) containing product information and 1 with 3 columns: Types, Functions and Partsgroup containing Filtercriteria. In the end I would like to have 1 query that shows me the first table with the Partsgroup added. (looks simple but it gets complicated)

In the partnumber table the Types field could contain values like
[X3, B5]
[B5, B2, A]
[A]
[D2,A]

and the Functions:
[Run]
[Run and swim]
[Walk]
[]

In the Filtercriteria table I have specified Partsgroups (1 to 100) with the criteria per field (as I would normally enter it in the criteria field of a query)
Example:
Group: [1] Type:[like "*b5*"] Function:[not like "*run*]
Group: [2] Type:["b5"] Function:[like "*run*]
Group: [3] Type:["a"] Function:[like "*run*" or like "*walk*"]

I hope you can help me! (I’m a novice in Access and know only a little about VB.)

Regards,

Marcel Megens