User Inputs in Query?

[Lluewhyn]

At my last company, we had a number of spreadsheets that would query our Access database for specific records. For some of these queries, a month's worth of records would be over 30,000 rows. Rather than always updating the date range in the query, I would just select the typical user prompts [Enter data here]. Go into the spreadsheet, hit Refresh, and put the date ranges you need.



I've set up a similar query at my current company with anticipation of a new project. I see where I can set up data ranges on a semi-permanent basis using filters, but how would I use a User Prompt like before? It's not a deal killer if I can't, just more annoying to the end user.

[Lluewhyn]

In case it wasn't obvious, I am talking about Excel 2016 vs. older models. Just trying to see if it's still possible to put a User Input in the criteria field like [Enter Start Date MM/DD/YYYY] as you could in previous versions.