473,839 Members | 1,519 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Creating Chart or Graph

180 New Member
How to make a chart or graphs base on the number of records in a queries? For example i have a queries name query1, query2, query3 and query4.
Feb 20 '12 #1
9 1571
12,516 Recognized Expert Moderator MVP
You could use a query that unions the count of all the queries as the source for your chart.
Feb 20 '12 #2
180 New Member
Thanks rabbit for your quick reply, how can i do that? can u give me example?
Feb 20 '12 #3
12,516 Recognized Expert Moderator MVP
Something like this
Expand|Select|Wrap|Line Numbers
  1. select count(*) from query1
  2. union all
  3. select count(*) from query2
Feb 20 '12 #4
180 New Member
after putting the chart in a blank form using chart wizard, where can i put your given code?
Feb 20 '12 #5
32,584 Recognized Expert Moderator MVP
The example code is SQL that can be used to produce the data for the question. If you need more than that then you need to ask your question properly. I believe I've made this point before, about a thousand times!!
Feb 20 '12 #6
180 New Member
I'm sorry coz i'm newbie, i don't get the example what rabbit given, where do start the coding.
Feb 22 '12 #7
32,584 Recognized Expert Moderator MVP
You've been a member of this site asking Access related questions for three years now. How can you describe that as being a newbie. If you're still a newbie after all this time then maybe Access isn't a good idea for you.
Feb 22 '12 #8
180 New Member
ouch.. that really hurts.. i admit i'm not good in access, but i will take this as a challenge. I will study hard about access to make you proud Neopa. Sorry for my poor english.
Feb 22 '12 #9
32,584 Recognized Expert Moderator MVP
Poor English is a valid reason for finding it difficult to explain your problem, as well as understand an answer that's been posted. There is no reason to apologise for that.

However, it's in your best interest to think clearly before posting questions, as you should understand by now that the clearer the question is, the more likely you are to find an answer that helps you. If your question consists of only a couple of short sentences, then there's a good chance that it's missing out too much detail, whatever language it's written in.
Feb 22 '12 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Frank | last post by:
I've written a jsp that retrieves data from a sybase table via the sql JSTL. Two colums of data are returned, date and value. Currently the data is placed in an HTML table. Does anyone know of a simple component that can put this on a simple line chart/graph? I'm hoping for a very simple solution in the area of a chart tag and the use of 2 arrays, 1 to hold the dates, 1 to hold the values.
by: JJ | last post by:
Hi, Can anyone reccommend a decent chart/graph component to use with asp 3 (Not ..net) Many Thanks JJ
by: David W. Fenton | last post by:
Is MS Graph really completely useless in Access 97? I uninstalled and re-installed to get the Office 97 version of MS Graph, but I see no way whatsoever to insert dynamic data into the chart. The wizard has got to be the worst wizard I've seen in Access, because it assumes way, way too much about what you want. And then when you click FINISHED, what you get has absolutely nothing to do with what you chose for the graph.
by: pmendez | last post by:
Anyone! I created a report that contains both a graph and its data. I have it set that the detailed data represents the data that is graphed. The graph is within the sorted sub-footer. The issue I am having is that when I run the report, most of the graphs match the appropriate record's data, but a few don't match, either they skip a record or repeat from the previous record. Any ideas how I can fix this problem?
by: BP | last post by:
Hello (this is _not_ a job posting!) I'm looking for an experienced C#/.Net programmer for a short-term project using Dundas and Quinn-Curtis charting frameworks. Does anyone know a decent online resource to locate (individual) contractors w/ this type of experience (or at least the ability to do some filtering)? Thanks for any info.
by: Robin Tucker | last post by:
Hi, I am embedding various things into a Microsoft Word document. I want to embed and automate a chart control. I can embed an Excel.Chart.8 into my Word document manually (no problemo), but I cannot find this control on the "Add/Remove Components..." dialog in the VB.NET editor. What I want to do is use automation to create an Excel.Chart.8, then using the reference returned, build a graph from my VB.NET program. What do I cast it...
by: Kuna | last post by:
Hi All, I am trying to create a gantt chart in php by getting data from database. I am using WindowsXp OS and having php-4 and my-sql DB. I have installed the JPGRAPH package to my system and including the jpgraph modules accordingly. I am able to create a gantt chart by hardcoding the datas but when I am trying to get the data from database then I am not able to get the chart it is showing errors. I think thre might be some problem in...
by: =?Utf-8?B?SmFj?= | last post by:
hi, I would like to create a Excel macro that can help me to create charts. First, I created the Excel macro as below:- Sub Macro1() Selection.CurrentRegion.Select ActiveSheet.Shapes.AddChart.Select ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$D$4") ActiveChart.ChartType = xlColumnClustered ActiveChart.ChartStyle = 4
by: TGG61 | last post by:
I have an Access 2000 query that asks the user for the start date & end date for a report or chart. In the Access report, I can display the start & end dates entered in the query in the header of the report. Problem: When I create a chart/graph using the same query, I am unable to display the start & end dates in the chart per the date prompts in the query. Any ideas on how I can display the date range in the chart/graph? Thanks much.
by: cozinon | last post by:
Hi there, If anyone could provide some coding, or tips to the following question it would be greatly appreciated. The version of MS Access I am using is 2003. My goal is to create a line chart for data across one record. The data format is similar to: Record contains Material Number, Demand 1, Demand 2, Demand 3, etc. I'm fairly new to coding, and could use a kick start in this area.
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.