Hi there, you could use the SUM function in your sql statement...like "SELECT SUM(count_view) FROM TABLENAME";
Hope this helps :) Joe Barry Rumsey <[EMAIL PROTECTED]> wrote in message 3C4C4D15.00000A.00872@weiz-main">news:3C4C4D15.00000A.00872@weiz-main... In one of my tables I have a field called count_view, How do I add all the totals up to come up with one grand total of views. ____________________________________________________ IncrediMail - Email has finally evolved - Click Here