Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brudderman

    Subreport headers on multible pages

    >>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...
  2. brudderman

    Subreport headers on multible pages

    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...
  3. brudderman

    Subreport headers on multible pages

    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
  4. brudderman

    Subreport headers on multible pages

    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...
  5. brudderman

    Subreport headers on multible pages

    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...
  6. brudderman

    Subreport headers on multible pages

    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...
  7. brudderman

    Subreport headers on multible pages

    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...
  8. brudderman

    Need to print subform with no records displayed

    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"...
  9. brudderman

    Need formula for report total

    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...
  10. brudderman

    Need formula for report total

    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...
  11. brudderman

    Need formula for report total

    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...

Part and Inventory Search

Back
Top