Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Report bring back sums for date (https://www.askmehelpdesk.com/showthread.php?t=158772)

  • Dec 3, 2007, 11:11 AM
    IowaGuy
    Report bring back sums for date
    Ok..

    I am trying to make a report that will sum up the results for 3 columns in the same table based on date.

    I have been using the wizard but all my results come out like this.

    1/4/2007 100 100 5
    1/4/2007 150 190 0
    1/4/2007 180 140 0
    1/5/2007 200 170 0
    1/5/2007 110 175 0

    All the columns are in the same table

    For now, I need is this.

    1/4/2007 430 290 5
    1/5/2007 310 345 0

    Any step by step help would be really apprecaited!
  • Dec 3, 2007, 11:21 AM
    ScottGem
    Use a Block style and set it for summary only.

  • All times are GMT -7. The time now is 01:36 AM.