By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,186 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Creating Chart or Graph

100+
P: 180
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
Share this Question
Share on Google+
9 Replies


Rabbit
Expert Mod 10K+
P: 12,315
You could use a query that unions the count of all the queries as the source for your chart.
Feb 20 '12 #2

100+
P: 180
Thanks rabbit for your quick reply, how can i do that? can u give me example?
Feb 20 '12 #3

Rabbit
Expert Mod 10K+
P: 12,315
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

100+
P: 180
after putting the chart in a blank form using chart wizard, where can i put your given code?
Feb 20 '12 #5

NeoPa
Expert Mod 15k+
P: 31,186
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

100+
P: 180
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
Expert Mod 15k+
P: 31,186
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

100+
P: 180
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
Expert Mod 15k+
P: 31,186
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.