Search results for query: *

>>I feel like I am shooting at a moving target. Yes, you are--and so am I, unfortunately. :( I apologize for all the confusion in trying to sort this out. Probably what I ought to do at this point is to try to construct a very simple example for myself and see if I can get that to work from...

I'm not smart enough to get there, Duane. Here's what I have for the simplified query based on what you set out: ***** qryAmtYTD ***** SELECT B1.TransactionDate, B1.donor_ID, B1.election, B1.election_year, B1.fk_CAM_ID, B1.amount, Sum(B1.amount) AS AmtYTD FROM tblContributions AS B1 GROUP BY...

I can easily understand the totals query part but am not sure about the other one. But I'll give it a try and see what happens. James

Thanks, Duane. I had once considered that but have the thing so tangled now that I'm not sure, with my limited understanding, that I can unravel the "inner" subquery from the "outer" query. But it seems like it might work. If you could mark in my code, with "**" perhaps, where the subquery...

Thanks, Duane. Here is the SQL view: SELECT b2.donor_ID, b2.TransactionDate, b2.amount, (SELECT SUM(Amount) FROM tblContributions as B1 WHERE (b1.TransactionDate<=b2.TransactionDate and b1.donor_id=b2.donor_id and b1.election=b2.election and b1.election_year=b2.election_year ) and...

Thanks, Duane! I tried this and get an error: "Multilevel GROUP BY clause is not allowed in a subquery." Then clicking on the help button for this dialog gives this: "An SQL subquery cannot list more than one field in a GROUP BY clause." This subreport is based on a subquery in order to...

I have a report with 6 embedded subreports. A couple of the subreports will sometimes flow to a second page. When this happens, I lose the header information on the subreport print on that second page. That's not critical in itself, but it would be nice to fix. What is critical is that the...

I have several subforms (unbound) based on different queries in the detail section of a main form. The fields are formatted with borders an aligned so that the print looks like a grid. In the footer of each subform I have a total based on a formula like this: =Nz(DSUM("amount"...

Both Amount and AmtYTD show on the subreport. I just got it to work by using DSUM instead of SUM: =DSUM("Amount", "qryMoneyItemized"). I still don't know why the original SUM formula won't work; must have something to do with the nature of the query. But I think I can get it from here...

Thanks, Tom! >> I gather that you are wanting to put a Sum in the main report footer, and there is a subreport involved. No, I want to put the Sum in the subreport footer, and that's where the error is coming in. If I can get that to work, I think I'll be OK. Sorry I wasn't more clear...

I have a subreport (Access 2003) based on a subquery to list amounts (Amount) and cumulative totals (AmtYTD) given by individuals to political campaigns for specified reporting periods (usually monthly). For a given date range I will only show contributors who made a contribution in that period...