Create & Populate Through Access Query And Their Values

Hallo,

I need your guidance to do the following;

On a click of a button from the Form the following should execute.
I have created 50 queries. Each query has more than 1000 recordsets.

1. I want to count the number of rows for each query (50 queries = 50 different values)
2. create one table and populate those 50 different values into the table
3. Using those values in the table; a Stack column chart has to be created.

In simple explanation; on a click of a button the data should be processed and chart has to be created.

Just a tip will also do to try on my side.

Thank you in advance