Aaron Young, you must know the answer... :-)

[Darkcloud]

I have a database that has a Feildname of "CustomerTotals". I need to code my program to get the entire column of "CustomerTotals" and add them all together and display their total as lblTotal.Caption. How do I add the entire "CustomerTotals" values together?
It shouldn't be that hard, I wouldn't think, yet I do not know the proper coding to make this possible.

I thank thee for any help,
Darkcloud

[bsmith]

Sorry I'm not Aaron Young, but you can try a select statement that looks like this:

Select GrandTotal = SUM(CustomerTotals) from myTableName

This will return the sum of all values in this column.

[This message has been edited by bsmith (edited 02-07-2000).]

[Darkcloud]

bsmith,

Thank you very much, I appreciate it.