M
Mark via AccessMonster.com
Count Aggregate Function
I have multiple independent queries and I need to get the number of records
each of them produced all in one query. I tired union all and was able to get
the required results but was wondering if there is a better way to get the
required data.
For example
Query 1 resulted in 100 records
Query 2 resulted in 25 records
Query 3 resulted in 10 records
The output should look like:
Query Name Number of Records
------------------------------------------------------------------------------
--
Query 1 100
Query 2 25
Query 3 10
Thank you,
I have multiple independent queries and I need to get the number of records
each of them produced all in one query. I tired union all and was able to get
the required results but was wondering if there is a better way to get the
required data.
For example
Query 1 resulted in 100 records
Query 2 resulted in 25 records
Query 3 resulted in 10 records
The output should look like:
Query Name Number of Records
------------------------------------------------------------------------------
--
Query 1 100
Query 2 25
Query 3 10
Thank you,