Get the total of a feild

2002-10-01 Thread Chuck Payne
Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. Chuck Payne Magi Design

Re: Get the total of a feild

2002-10-01 Thread nellA hciR
sounds like you need SUM(field name) - hcir Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.

Re: Get the total of a feild

2002-10-01 Thread nellA hciR
sounds like you need SUM(field name) - hcir Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.