Briefly about reports, or how to do less than access offers as a standard?

Question

Analytics

In short, there is a new database that should store various data for accounting and statistics, and if I figured it out, then the problem with statistics is that I don’t know which way to approach the issue.

Thinking out loud

С точки зрения создания запроса на каждый такой случай - проблем по сути нет, кроме того, что их по итогу будет 1000+)

В качестве выделения диапазона использую *Как бы это не было банально и удивительно* Between, а дальше продолжаю фильтровать запрос, пока не останутся только нужные позиции.

In fact, you need to create a report that will issue the number of certain positions for a certain period of time. and the problem is:
a) How to let the user enter the range of dates of interest to him on his own, and simply (perhaps it will be an old woman of 60 years old, or even worse, just an employee who does not want to learn anything).
b) How to correctly implement the output of such a report, because creating a request file for each value is too complicated and not a simple structure.

If someone knows how to solve such problems, could you explain the principle of the solution, or give a link to an article that describes similar case?