com wrote:
Hi Does anyone know how calculate the total value of the results of a selected field....
Hi
Does anyone know how calculate the total value of the results of a
selected field.
com wrote:
com wrote:
[/ref]
er... SUM?
strawberry wrote: [/ref]
>
> er... SUM?[/ref]
sum total my mistake as in john made three payments $1.00 $3.00 $ 2.00
sum total is $6.00
com wrote:
> >
> > er... SUM?[/ref]
> sum total my mistake as in john made three payments $1.00 $3.00 $ 2.00
> sum total is $6.00[/ref]
SELECT SUM(payments) AS total FROM table WHERE name = 'John';
Bookmarks