Hi,
It seem straight forward but I am not sure if this is doable or if I am missing something.
I have 4 queries that pull information from the same table but each query have unique criteria.
I am trying to create one query that will count how many records each of the 4 queries has so that I can show it on a report.
QRYcount when executed will show me one row with 4 columns containing the count of records in each of the query as follows
QRY1 QRY2 QRY3 QRY4
35 10 200 4
Is that possible and if so how....any help or tip are greatly appreciated
Thanks in advance
It seem straight forward but I am not sure if this is doable or if I am missing something.
I have 4 queries that pull information from the same table but each query have unique criteria.
I am trying to create one query that will count how many records each of the 4 queries has so that I can show it on a report.
QRYcount when executed will show me one row with 4 columns containing the count of records in each of the query as follows
QRY1 QRY2 QRY3 QRY4
35 10 200 4
Is that possible and if so how....any help or tip are greatly appreciated
Thanks in advance