Results 1 to 3 of 3

Thread: sum totals

  1. #1
    Join Date
    Mar 2004
    Location
    New York City
    Posts
    5

    Wink Unanswered: sum totals

    Is there away that I can get my monthly totals??

    Page Header = YTD Monthly
    Actual Actual

    Group Header= SumOfExpense ?????

    Report Footer= =Sum([SumOfExpense]) ???

    My year to date works well but when I try to get the month to date expense I get and error of the same total as YTD.

    Field = Expense
    Table = Invoices
    Total = sum

    Hope that this makes sense. Thank in advance for any ones help.

    David200

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: sum totals

    Originally posted by David2004
    Is there away that I can get my monthly totals??

    Page Header = YTD Monthly
    Actual Actual

    Group Header= SumOfExpense ?????

    Report Footer= =Sum([SumOfExpense]) ???

    My year to date works well but when I try to get the month to date expense I get and error of the same total as YTD.

    Field = Expense
    Table = Invoices
    Total = sum

    Hope that this makes sense. Thank in advance for any ones help.

    David200
    Do you have a date column or a month column? If so, you can group on it and get a subtotal ...

  3. #3
    Join Date
    Mar 2004
    Location
    New York City
    Posts
    5

    Post still not working

    No I do have a date column an a month column but when I group it my totals chagne for my YTD.

    My report look like this:
    YTD Monthly
    Actual Actual

    The YTD sum up Correctly but my monthly totals will not. any ideas I will be very greatful

    Thanks
    David2004

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •