How to total a column

bambamn007 · #1 (**permalink**) 02-02-03, 04:58

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

izyrider · #2 (**permalink**) 02-02-03, 09:12

maybe not the fastest, but possibly the simplest:

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

izy

bambamn007 · #3 (**permalink**) 02-02-03, 10:34

Quote:

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

izyrider · #4 (**permalink**) 02-03-03, 02:03

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

Internet Services

Web Development

Digital Marketing

Consumer Tech