473,320 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Creating a report of Metrics

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.

Jun 21 '06 #1
4 3991
<ja********@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
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.


You need to include your three separate queries in another query and base
your report on that.

HTH - Keith.
www.keithwilby.com
Jun 21 '06 #2
Can you please elaborate?

I'm not sure what you mean by including them in a separate query?

perhaps an example. is the SQL then just appended all together?
Keith Wilby wrote:
You need to include your three separate queries in another query and base
your report on that.

HTH - Keith.
www.keithwilby.com


Jun 21 '06 #3
<ja********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Can you please elaborate?

I'm not sure what you mean by including them in a separate query?

perhaps an example. is the SQL then just appended all together?


Save your three queries. Open a new query and click the add table button.
Click the queries tab and select your three saved queries. Drag the fields
from your queries onto the grid. I tried it on a simple example and it
seemed to work OK. No need for any joins.

Regards,
Keith.
www.keithwilby.com
Jun 21 '06 #4
Thank you. Worked like a charm.

but now I want to add in a "Notes/Explanation" Column which I'm finding
hard becuase I know that this report is made up from about 20+ queries,
but I dont want to have to put in 20+ labels when the report is
created.

Right now I have my reporting looking like:

Query1 Result1
Query2 Result2
Query3 Result3

but I need soemthing like:

Query1 Result1 Notes1
Query2 Result2 Notes2
Query3 Result3 Notes3

1) Is it possible to create perhaps a TABLE of my results now rather
than a REPORT of course in an automated process? Either throught VBA or
throught MS Access interfaces
like so:

QueryName | Result | Notes
------------------------------------------------------

so that I can just type it in to the table and then print out the full
results in the end to a report?


Keith Wilby wrote:
<ja********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Can you please elaborate?

I'm not sure what you mean by including them in a separate query?

perhaps an example. is the SQL then just appended all together?


Save your three queries. Open a new query and click the add table button.
Click the queries tab and select your three saved queries. Drag the fields
from your queries onto the grid. I tried it on a simple example and it
seemed to work OK. No need for any joins.

Regards,
Keith.
www.keithwilby.com


Jun 23 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Edward Berard | last post by:
I am looking for tools that will analyze Java source code: -> I am primarily looking for metrics tools, e.g., tools that will tell me things like - Total lines of code - Total blank lines...
9
by: Markus Minichmayr | last post by:
Hello! Does anyone know a free tool to collect source code metrics like lines of code, no. of classes, etc.? Thanks Markus
6
by: Larry R Harrison Jr | last post by:
I have Access 97, and I have a report with a text box which has the "Can Grow" set to yes. Regardless, it still doesn't show all the data of the tet box. It does grow vertically, but the data...
7
by: Michael Deathya | last post by:
Hi, I am pulling over 400 different metrics from an Excel spreadsheet into Access (97). Conceptually, each row represents a single set of these 400 metrics. However, because of the 255 column...
1
by: khammond | last post by:
I'm an Enterprise Architect at a large insurance company. My background is Java, and I have brought in the CodePro metrics & code audit tool that runs automated metrics and code audits within...
0
by: neelagain | last post by:
Hi, I have seen in COM+ that we can use ComSpy.dll to get the metrics of COM+ application using IComMethodEvents, IComTransactionEvents, IComInstanceEvents and so on.. Is there a way to get the...
7
by: TC | last post by:
I've produced an Access application for a client. For one report, text gets cut-off at the right margin when we print the report. It does this only when we print; it doesn't happen when we view the...
10
by: Snoopy33 | last post by:
I have a DB that I developed on access XP (2002) and deployed over a year ago. No one has had problems printing any of the reports within the DB until we started loading 2007 on new computers. ...
2
by: Zammy | last post by:
I wrote a program in Access 2000 for a co-worker. She just got a new Dell Latitude laptop and when she opens the db, none of the reports will open. They show up in the report section with the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.