field+field = insert into field total

[Anon]

SELECT SUM((run + swim + bike) / 60) AS TOTAL FROM runner WHERE name= "joe";

Works great, Big thanks to Paul<G>

How do I take the totals of the fields and put the total in a field called total.

Make sense

[cordex]

I haven't tried this but if I had to guess:

UPDATE runner SET total="SUM(run + swim + bike)" WHERE name="joe"
or
UPDATE runner SET total="(SUM(run + swim + bike) AS TOTAL FROM runner WHERE name="joe")" WHERE name="joe"

[Anon]

I tried basicly the same thing but it wont add up the fields and put the total in the total field

[Anon]

Try....

UPDATE runner SET total = (run + swim + bike)/60 WHERE name='whaterver'

[Anon]

Thanks Paul

m;-)