Re: Couple of small questions

In a message dated 20/11/2000 09:36:42 GMT Standard Time, jeremy@nirvani.net writes: << SELECT count(*) from tablename; This works fine thank you > and secondly in a table > I am storing a value under the name Gram every time a record is added this > value is different what I am trying to do is select all the records take Gram > from each record and add them all together, any ideas. I'm not quite following you. >> Ok what I mean by this, say I have 3 records in my table like so: Record 1 - Gram = 10 Record 2 - Gram = 10 Record 3 - Gram = 5 I want to select Gram and add all the results, so my output in this scenario would be 25.