Topic: The list of values as the table in request - how to make?
Kind time of days.
There is a table of events with type records (Date, Event).
It is necessary to count an amount of events with grouping on years, since the earliest and to the leaking. Thus, if in the given year of events was not, it is necessary to specify "0" as an amount of events.
Question: how to generate request that have been deduced sequentially all year - without passes?
I so understand that I in the request text dynamic I will generate table Years (Year) and c c it available table Events (Date, Event). But how to generate table Years - I do not know.