Need help with a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Please give more information about the fields in the tables.... how do
member and organization relate, for example?
 
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.
 
Back
Top