Re: Couple of small questions

> Need some help with some math stuff. Firstly, what is the best method for > obtaining the number of records stored in a db table? SELECT count(*) from tablename; > 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. -jeremy brand Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: jeremy@nirvani.net http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more - - - - - - - - - - - - - - - - - - - - - - - - - I am pleased to see that we have differences. May we together become greater than the sum of both of us. -- Surak of Vulcan, "The Savage Curtain", stardate 5906.4