In your 11th column, enter this:
Ifnull(Tablename.columnname1,0)+ifnull(tablename.columnname2,0)+....
You get the idea. The purpose of the if null function is that if any of the 10 columns have a null value it will still add the rest of the values in the other columns.
Until Next Post... :)
No comments:
Post a Comment