I have a query that uses a tbl
fields
Bea
BeaID
qry
ToBeaID
Quarter
Amount
qry
FromBeaID
Quarter
Amount
the two query are outer joined with BEAID on TO and From.
I group by BEAID and by Quarter. Then I want to display the sum of FromBEAID and the sum of TOBEAID. The problem is it is...