Topic awaiting preservation: Yet another MS Access question... (Page 1 of 1)

You'd think that I could find this information in a help file somewhere. I swear! Training classes are not offered frequently enough...

Here's the deal:

I am trying to create a report that will allow me to get the total number of students who have a 2.0 GPA and above, as well as those who have a 1.99 GPA and below. I need to be able to figure the percentages based on the academic year they entered the program. The counting and the percentages are not the problem. It's getting the students separated into the 2 groups. I'm sure the answer is something that will seem very simple when I hear it...

At the moment, I've got 2 queries, one for each group of students, but Access tells me I can't use both queries in one report. (Got to love a program that thinks it's smarter than you are...)

I need an answer to one of 2 questions:
1. What expression would I use that would allow me to group all the students 2.0 and up and then all the students 1.99 and below?

or

2. How do I create a report that allows me to use the information from 2 queries and group accordingly?

Honestly, for all this trouble, I could do it manually in Excel, but that's beside the point.

Any assistance any of you can provide would be most helpful!
Thanks!


Cell Sweet Cell

Well, you could do it with two pieces of SQL. In semi-pseudo code you'd have

Select all records from the GPA table where GPA <= 2.0 order by GPA DEC

Select all records from the GPA table where GPA > 2.0 order by GPA DEC

Then just pull up these two queries into two different text areas and you have your grouping.


Justice 4 Pat Richard

Let me try it creating a manual report and see what happens. That's what I was thinking, but then I got an error message from Access when I tried it through the wizard...
Thanks!

Another option is to utilize a sub-report. This will allow you to reference the second query that you create and group as you wish.

I tried the sub-report, but I don't know enough about working with them yet to make it work the way I want it to... that's definitely on the training roster for next year!

I decided to go around the problem and I've printed out 2 reports and manually tallied them up on an Excel spreadsheet. Time is of the essence and I don't need to waste it trying to figure out how to make Access do what I want it to right now. But I'll have to do the same stuff next year, so I'll have to figure it out eventually!

Thanks, as always, for your help!