Displaying the results of multiple queries on one form

[Reppers]

Hi all,

This is my first post, so please bear with me if I forget something out which you need to help me!

I'm creating a database for my school to monitor pupils progress. All of the information I need for this problem is in one table.

I want to be able to show overviews of children progress for 5 different areas - Reading, writing, numeracy, science, and speaking and listening. I've worked out how to display an average of these 5 columns, so that bit's sorted!

However, I also want to be able to isolate groups of pupils and display their average progress on the same form for easy comparison. For example, I want to isolate all of the males, and then show their average progress on the same form.

I hope this is making sense so far!

I have created a number of queries which (independently) do the job of isolating groups and averaging them - so I have qryMale which searches the Gender column for "M", and then used the Totals section to get an average of the ReadingProg, NumeracyProg, etc colums.

My issue is getting them all to display on one form. Do I need to link them all into some kind of overviewing Uber query? And if a query returns no results (for example there stops being any dyslexic children within the school), will that cause my form to freak out and display #Error all over again!?

Any help would be greatly appreciated. I apologise that this has rambled a little, and if I have missed anything crucial for a solution, just let me know!

Cheers

 

[Neen]

Hi

There are a couple of things to do.

1) If you havent already, go to reports, and follow the wizard to create a report showing the key information you will always need - your master report.


You say you have your queries that you need to section out each group, e.g. the males. This is fab. What you need to do is create a report for each of the queries you have that you want to show data for.

Once you have done all of these, open up your master report, in design view.

Open up the Toolbox (usually a hammer and spanner button). Click the 4th symbol from the right on the little bar that comes up - this is add subform. What you then do is link this through the wizard and select the subform as one of the new reports you just created e.g. for males only.

If this doesnt make sense let me know and i will try to help some more.

 

[Reppers]

Genius!

I knew it would be something painfully simple. Cheers!

 

[Neen]

That's often the thing with Access, once you know you go "ohhh riggghhttt, of coursse" which is what i am hoping happens in response to my own query about merging fields!

Good luck with your reports. (If it starts fannying around saying things about page widths, go into each reoprt, page setup, make the columns 20cm and the margins 2cm each - another little annoying thing which took me ages to work out how to do when i started using reports)