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.