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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Amfine

  1. Amfine

    Alternating White and Gray Bars (rows)

    Thanks for your help. TH
  2. Amfine

    Alternating White and Gray Bars (rows)

    Thanks for the idea. I'm not sure how to set up some sort of counter as you suggested. Do you have any recommendations? TH
  3. Amfine

    Alternating White and Gray Bars (rows)

    I would like to know how to alternate each row of a report with white and gray bars. I am currently using Access 2003. Any help would greatly be appreciated. Thanks, TH
  4. Amfine

    Running Sum

    Thanks so much for your help. You were right, the problem was in the placement of the () in the calculation formula. Thanks again for your help.
  5. Amfine

    Running Sum

    Yes, I'm using the date field to do my monthly grouping. That is what I can't figure out. I have one field in a form that shows the total of the record entered. I am using the following function to make this happen...
  6. Amfine

    Running Sum

    Yes, I do have a date field in the table.
  7. Amfine

    Running Sum

    I'm not understanding what your saying. I setup my report to group by month. (Month field is actually a lookup field, ex. January, February,....etc.) I am asking it to give me a monthly total in the Month group footer using the calculation above. I can't figure out what I am doing wrong. I...
  8. Amfine

    Running Sum

    Yes, the field I am grouping is the total of multiple fields within one table. I have one field in a form that shows the total of the record entered. I am using the following function to make this happen...
  9. Amfine

    Running Sum

    When I copy the the field to the footer, =Nz([Waste],0)+Nz([FacilityCharge],0)+Nz([TankWash],0)+Nz([H2O/BTU/Solids/Weight Surcharge],0)+Nz([StateFee],0)+Nz([Transportation],0)++Nz([Insurance/SecurityCharge],0)+Nz([Loading Demurrage&Equipment],0) For some reason it just won't add up correctly...
  10. Amfine

    Running Sum

    Sorry for the confusion. Yes, I have groups setup by month. I was trying to show the totals in the group footer by month. Is this possible?
  11. Amfine

    Show Total in a Form

    Thanks for your help? I had 1 small typo. Tim
  12. Amfine

    Running Sum

    I am currently using the following function in a form to show total of each record. =Nz([Waste],0)+Nz([FacilityCharge],0)+Nz([TankWash],0)+Nz([H2O/BTU/Solids/Weight Surcharge],0)+Nz([StateFee],0)+Nz([Transportation],0)++Nz([Insurance/SecurityCharge],0)+Nz([Loading Demurrage&Equipment],0) I...
  13. Amfine

    Show Total in a Form

    I tried using the Nz function: =Nz([Waste],0)+Nz([Facility Charge],0)+Nz([Tank Wash],0)+Nz([H2O/BTU/Solids/Weight Surcharge],0)+Nz([Loading Demurrage&Equipment],0) I am getting #Name? Any idea what I am doing wrong. Thanks, Tim
  14. Amfine

    Show Total in a Form

    I have a form with 8 entries and would like to show a total of all 8 entries in each record. example: Wst FacChrg twash Wgt Stfee Trans Secr Load Total 500 100 50 36 50 100 75 50 ???? 400 100 45 25 75 200 60 45...
See more

Part and Inventory Search

Back
Top