P
Pattyt
Hi All,
I've reached a point where I have confused myself. I have three tables:
Table 1 holds Member Information (MemberId, Name, Address, etc) Table 2 holds
Pledge Info(MemberId,Amount, Date, PledgeID, etc) and Table 3 holds Payment
Info(Member Id, Pymt ID, Amount, Date). Table 2 & 3 are related to Table 1
by the MemberId field present in each table.
My problem comes when conducting a query in which I want to see the sum of
pledges and sum of payments for a given member. I created seperate queries,
one to show pledges and one to show payments. How can I combine both to get
one query only without having duplicate entries?
I've reached a point where I have confused myself. I have three tables:
Table 1 holds Member Information (MemberId, Name, Address, etc) Table 2 holds
Pledge Info(MemberId,Amount, Date, PledgeID, etc) and Table 3 holds Payment
Info(Member Id, Pymt ID, Amount, Date). Table 2 & 3 are related to Table 1
by the MemberId field present in each table.
My problem comes when conducting a query in which I want to see the sum of
pledges and sum of payments for a given member. I created seperate queries,
one to show pledges and one to show payments. How can I combine both to get
one query only without having duplicate entries?