Making gragh out of forms

[samcooldude1430]

Dear Experts,

I want to make graph from the queries. I have 50 such queries.

How to achieve this without repetition for each query.

 

[apr pillai]

The following links may be helpful:

http://msaccess-tips.blogspot.com/2007/08/ms-access-and-graph-charts.html

http://msaccess-tips.blogspot.com/2007/09/ms-access-and-graph-charts2.html

http://msaccess-tips.blogspot.com/2008/02/crosstab-union-queries-for-charts.html

 

[plog]

How to achieve this without repetition for each query.

Actually the repetition needs to eliminated at the query level. My guess is that those queries need to be combined into 1. Most likely you have a query for every X (where X is Day of the Month, Salesperson, Company, etc.) and instead X should be a value in a field inside the query, not in the query name.

Once you do that you can create a graph that shows your graph for each X. Or you can have a one graph with a segment for each X. Perchance, what's the difference between these 50 queries that the data inside them is relatively the same structure that they lend themselves to the same graph layout?

 

[plog]

Thought I remembered your screen name. This sounds like yet another symptom of your main issue:

http://www.access-programmers.co.uk/forums/showthread.php?t=289274

Normalize, normalize, normalize.