Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    32

    Unanswered: How to total a column

    I know this is something simple, at least I think it is.
    I have a table with the following columns:

    name | score1 | score2 | name2

    what I want to do, is to have a field somewhere, that has a total for all numbers in column score, and a field that has a total for all numbers in column score2. how can I do this? I am posting the results to a table on a website that has the total fields at the bottom of the columns.
    Any help will be appreciated.
    Bam

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    maybe not the fastest, but possibly the simplest:

    set the data source of a text box to
    dsum("[score2]", "theNameOfYourTable")

    izy
    Last edited by izyrider; 02-02-03 at 10:19.

  3. #3
    Join Date
    Jan 2003
    Posts
    32
    Originally posted by izyrider
    maybe not the fastest, but possibly the simplest:

    set the data source of a text box to
    dsum("[score2]", "theNameOfYourTable")

    izy
    This may sound crazy, as I am new at this, but where do I find the data source of a single text box? I have access 2002 if that matters.
    Bam

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    open a form or report

    add a text box.

    View¦Properties to display the properties window.

    click your text box once to show its properties in the properties window.

    in the properties window under the Data tab you will see Control Source... you type:
    =dsum("[score2]", "theNameOfYourTable")


    izy

Posting Permissions

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