Form based on multiple queries

[Noreen]

Hi there,

I'm not too sure how to phrase this so I will try to explain as best I can:

I have a access db based on a course running - 3 tables:
1. Students,(who belong to a country)
2. Modules and
3. Exam Results

I created these queries:
1. Average for the course as a whole per module
2. Average for each class per module
3. Average for each country per module
4. Average for each student as a whole

I now need to merge these into a form in a chart form - to compare each to each other with combo boxes to choose:
Student Name:
Country:
Class:

and the chart to update the comparisons.

Is this easily done? I am not a beginner but I am not an expert either - I have understanding of access.

Any help would be much appreciated!

 

[the_net_2.0]

To compare them...what do you mean? Compare them record to record? How many records are in each query? Would it be possible for you to post the query results here? You can use the

tags to do that if they are not too big.

And do you need a chart? Charts are mainly for data series, so if each query has only one record, a chart is not going to do you much good because it won't have much to work with.

Charts also create crosstab queries automatically when they are made from the wizard, which is another thing to consider here as well. If this data could be organized and output in a compatible way through a crosstab, it would make life simpler in some sense of the word...

 

[Noreen]

To compare them...what do you mean? Compare them record to record? How many records are in each query? Would it be possible for you to post the query results here? You can use the

tags to do that if they are not too big.

And do you need a chart? Charts are mainly for data series, so if each query has only one record, a chart is not going to do you much good because it won't have much to work with.

Charts also create crosstab queries automatically when they are made from the wizard, which is another thing to consider here as well. If this data could be organized and output in a compatible way through a crosstab, it would make life simpler in some sense of the word...

I actually think I fixed this yesterday, I created a query that merged all the other queries together by using joins. I then created a chart from that and the results are fantastic. However, now the only problem I have is that I want to change the name that appears on a legend is this possible?

Thanks a million for your help