Chapter 5. Query Parameters

Chapter 5. Query Parameters

Let's return to Alex's workbook and run Reload, Configure Query Parameters:

Configure Query Parameters

Check the check boxes in the W (WHERE) column for the Account, Company, and Item columns:

Change SELECT and WHERE fields


The SaveToDB add-in places the selected columns to the ribbon. So, you can filter data:

Sample of WHERE fields at the Excel ribbon

Let's choose the Revenue item:

Sample of the filtered data

This feature allows working without auto-filters and loading fewer data.