Need help with a query

[Guest]

parent table is Member, child is Transaction....there are 3 types of
transactions: equity deposit, refund, and gift to org. I need a query that
shows how much equity the org. has at any given time and I belive it is equal
to: sum of deposits - sum of refunds - sum of gifts, for each member.

Worse, the are four types of members and I need the "sums" summed for Member
type in (Full, current, noncurrent)

I've tried some "simpleton" things in design view but am getting nowhere.
Your help is appreciated.

HB

 

[Ken Snell [MVP]]

Please give more information about the fields in the tables.... how do
member and organization relate, for example?

 

[Guest]

Actually, I just got it. Tried another simpleton approach. Created three
separate queries, one that summed deposits, one that summed gifts, and one
that summed refunds. Then, created a query and put all the above three into
it, selected the sum field, then added a field that subtracted as necessary
and it worked!

But to answer your question....members make up the organization....they are
the parent table....and can have multiple (child) transactions.

Thanks for responding.