Hi,
I am trying to create a table of Query "Metrics"
ie. I have many tables in a database which most of the time just counts
the number of rows in a certain table, or the number of distinct rows
in a table with some condition.
I'm trying to use the MS Access built in report feature to create one
master "metrics report"
where it will just have sample output such as:
#Rows in Table: 25034
#Distinct Rows: 135
#rows where condition is true: 55
....and so forth.
I can create the seperate queries with no problems. ie. I can create
one query which counts the number of rows in a table, and another for
the distinct rows, and another where the condition is true. but what I
cannot do is put them all on the ONE FINAL REPORT.
If I use the built in wizard, it will be able to create only 1 query in
each report. As the report 'Record Source' is to bound to the Query
Name. whereas I need my report to place the results of all the queries
into just the one table.
Is this possible to do?.. if so, how?
Thanks in advance.