If using query-by-form, what would be the best way to handle a user defining parts of the WHERE clause via a combo box (example below)? I am new to Access and not sure if I need to build a SQL query from scratch based on input or use some sort of built-in filtering or something else? The only solution I have found seems to be making individual queries for each option but I doubt that is the best solution.

Below I have an example combo box showing options for filtering a numerical field. I don’t know the best way to incorporate the user-chosen value of this box into a query.
a dropdown box showing different filter criteria for a query