Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    35

    Unanswered: Sum Across Columns

    I have a table in column one is the date and each other column is a day in the week, in each cell is a number.

    How can I sum all the days in the week?

    I am thinking a query, something like
    [monday]+[tuesday]+etc.

    I did this but if there was a null in a cell it ignored the whole week.

    Any suggestions.

    I am not a pro but I do understand Access.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Hillsboro, OR, USA
    Posts
    59

    Re: Sum Across Columns

    Try:

    nz([monday],0)+nz([tuesday],0)+etc.

    The nz() function returns the second parameter if the first parameter
    evaluates to null.

    Better yet:

    Set the default value for the day fields to 0 and Nulls Allowed: False

  3. #3
    Join Date
    Jul 2002
    Posts
    35
    It worked, Thank you.

Posting Permissions

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