Ok I am not suer why I can't figure this out, howver I have never had to SUM things, Please pardon me.
Table Set up
MailingListID (Rekated to SupporterID)
I have a mainform of Supporter information with sub form of Donation
I would like a text box on the Mainform which will calculate the total donations for that particular person active in the main form. Can someone give me a hand?
I've been following this discussion and had requested something similar earlier.
To recap, I have queries that has data of contracts with customers, each starting at some date. I also have some statistic on these contracts (sales of products by month).
My report can group and summarize by QTD, YTD across all customers - but this summary uses the calendar year quarter.
I have been trying to get a summary by customer and QTD/YTD, defined by their respective contract StartDate. If a contract starts in May, <its> quarter would be as follows: Q1: May-July; Q2: Aug-Oct; Q3: Nov-Jan; Q4: Feb-Apr. Each contract StartDate, thus, should have its own defined quarter and the summary would give sales aggregation for every three months from its StartDate.
Short of writing extensive code, is there a way out? I've tried IIF(), SWITCH(), etc but can't seem to crack this one.