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

    IF, Then, Else Statement

    Can anyone tell me why I am &quot;missing an operator&quot; in this expression? Bonus Amt: If([SumOfQuantity]>75 and <101) Then =([SumOfQuantity]*5) ElseIf ([SumOfQuantity])>100 Then =([SumOfQuantity])*10) End If
  2. JulieAnnL

    Report with 4 subforms - need grand total

    HEY! It worked this time. My report is complete. THANKS SO MUCH!!
  3. JulieAnnL

    Report with 4 subforms - need grand total

    I already did this step (#8). It worked great. Where my problem lies in in creating the text box that adds the totals together. I keep getting the parameter boxes. I think this means my expression is not correct. I tried: =Sum(([Category 1 Total])+([Category 2 Total])+(Category 3...
  4. JulieAnnL

    Report with 4 subforms - need grand total

    Thanks for your help! I read the article you referenced and I must be missing something. In the sample, it only uses one subreport. I don't see where it explains how to add the totals for more than one subreport.
  5. JulieAnnL

    Report with 4 subforms - need grand total

    I have a report with 4 subforms (one for each category). The category totals are in the subform, category footer. I need to add all these totals together for a grand total, but nothing I try works.
  6. JulieAnnL

    Report Subform Totals

    I have a report with 4 subforms for 4 categories. I have category totals in the subform footer. My problem is that I can't get a grand total for all the category totals. Any suggestions would be greatly appreciated as my sanity is at stake. I'm thinking that maybe I'm trying to to the...

Part and Inventory Search

Back
Top