education db help

[marc]

I have an education db that yields student results on the District Level...In
other words, District 'AAA' has 50 kids in the 9th Grade, 25% of the total
kids are in the 5th Grade, a Relative Difference of .32 regarding the
District and State totals of kids who have some type of hearing impairments,
etc., etc., etc...Districts 'BBB', 'CCC', etc. have the same column headers,
just with different sums and totals...

The way the db is currently constructed is that the end user of it will open
up a Report, imput the District ('AAA') that they want and only the results
from just 'AAA' will appear...This is how the owners of the db originally
wanted it a few years ago, just being able to view one District's
information...

But now, they would like to combine a few Districts and their Totals
(Regional Totals)...In other words, they would like to see the results of
'AAA', 'BBB' and 'CCC' all combined into one report with the same format as
they are used to (say, the sum of those 3 Districts, yielding 175 kids in the
9th grade)...

I'd imagine that I'd have to do something with the query...But, I'm not sure
what...

Is this somehow do-able in the current db???
Thanx in advance,
m

 

[Ken Sheridan]

You might be able to do it simply by using the IN operator and a value list
of districts to restrict the query. The IN operator does not accept
parameters, however, so the best way is to base the report on a query without
parameters and open the report in code from a dialogue form. This could have
a list box on the form from which multiple districts can be selected.

Before attempting that, however, find out if the report gives the correct
results by temporarily amending its query so that it restricts it to a number
of districts. To do this put something like this as the criterion for the
District column in query design view and save it:

In("AAA","BBB","CCC")

Then open the report. If it gives the correct results you can then design a
dialogue form for selecting variable district lists for opening the report.
If you need help on that post back.