problem with report

[Rsosa]

HI,

I need help creating a report. I have a table that list student in
group a by location, the same table has the student in group b by location.
group b is a subset of group a. I would like create a report that list all
the groups and provide a sum of location a and location b side by side. see
below:

(in progress is a variable that subtract group a , from group b.)


Dist in progress late total

01 5 7 12
etc..


I can get this to work, because group a and b are in the same
database, so I can not subtract the record of one field, from a different
record and different field.


Help!!!!

Thanks,
Robert.