Creating Chart or Graph

[eneyardi]

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.

[Rabbit]

You could use a query that unions the count of all the queries as the source for your chart.

[eneyardi]

Thanks rabbit for your quick reply, how can i do that? can u give me example?

[Rabbit]

Something like this

select count(*) from query1
union all
select count(*) from query2

[eneyardi]

after putting the chart in a blank form using chart wizard, where can i put your given code?

[NeoPa]

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!!

[eneyardi]

I'm sorry coz i'm newbie, i don't get the example what rabbit given, where do start the coding.

[NeoPa]

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.

[eneyardi]

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.

[NeoPa]

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.