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

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

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

Code:

---

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).]

bsmith,

Thank you very much, I appreciate it.