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 may 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.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK