469,366 Members | 2,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Creating Chart or Graph

180 100+
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 1288
Rabbit
12,516 Expert Mod 8TB
You could use a query that unions the count of all the queries as the source for your chart.
Feb 20 '12 #2
eneyardi
180 100+
Thanks rabbit for your quick reply, how can i do that? can u give me example?
Feb 20 '12 #3
Rabbit
12,516 Expert Mod 8TB
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
eneyardi
180 100+
after putting the chart in a blank form using chart wizard, where can i put your given code?
Feb 20 '12 #5
NeoPa
32,185 Expert Mod 16PB
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
eneyardi
180 100+
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
NeoPa
32,185 Expert Mod 16PB
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
eneyardi
180 100+
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
NeoPa
32,185 Expert Mod 16PB
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

Post your reply

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

Similar topics

1 post views Thread by Frank | last post: by
3 posts views Thread by JJ | last post: by
6 posts views Thread by David W. Fenton | last post: by
reply views Thread by pmendez | last post: by
1 post views Thread by Robin Tucker | last post: by
5 posts views Thread by Kuna | last post: by
reply views Thread by =?Utf-8?B?SmFj?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.