Solved

Need Query for histogram

Posted on 2004-09-17
2
206 Views
Last Modified: 2012-06-27
I need the proper syntax for a histogram. Name of table: tblinprocess, field, timestamp. How do I get the totals I need for a histogram. Thank you for the response.
0
Comment
Question by:marlind
2 Comments
 
LVL 11

Accepted Solution

by:
miqrogroove earned 500 total points
ID: 12104709
Marlind, there are probably several ways to attack this problem.

As you know, a statistical histogram requires not only the input data, but also "bins" specified by sizes or ranges.  Could you describe for me how you want the bins arranged, how you will determine that arrangement, and will it change dynamically?

A histogram with static bins can probably be designed using one or two queries with both IIf statements and Sum functions.

A dynamic histogram system will need to have the bins pulled from a second source and will require a more complex query, or possibly even some programming code.

Also, if you would, describe the end product you need.  If you need a histogram chart, then perhaps designing a PivotTable or exporting data to Excel would be a better approach than using queries at all.

-- Miqro
0
 
LVL 2

Author Comment

by:marlind
ID: 12105008
Those are good questions. Let me put some thought into the questions and get back to you.
Thank You.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question