I have a Customer table, a Donations table and a FundSplit table. Relationship: (Customer <->> Donations <->> FundSplit)
Customer Fields: CustID, Name, ... (address fields)
Donations Fields: CustID, DonationID, Date, ...
FundSplit Fields: DonationID, Amount, TaxDed, ...
What I am after is a query (or queries) that will yield a record with the following fields:
CustID, Name, (the other address fields), DeductableAmount, NonDeductableAmount
Where Date > 12/31/2003 and <= 12/31/2004
I'm learning, but seem to be having difficulty with this one.
Can someone help me here?
Thank you!
grwd
tim@tgm.org
Customer Fields: CustID, Name, ... (address fields)
Donations Fields: CustID, DonationID, Date, ...
FundSplit Fields: DonationID, Amount, TaxDed, ...
What I am after is a query (or queries) that will yield a record with the following fields:
CustID, Name, (the other address fields), DeductableAmount, NonDeductableAmount
Where Date > 12/31/2003 and <= 12/31/2004
I'm learning, but seem to be having difficulty with this one.
Can someone help me here?
Thank you!
grwd
tim@tgm.org