Rashar
05-07-2004, 03:09 PM
Hi,
I have the following script that will sum values in a column... How can I modify this script to sum values in a row.
Thanks in advance.
Script to sum values in column.
SQL2 = "SELECT SUM(Hours_Approved) AS Hours_Approved FROM TBLAGTREQUEST WHERE EMP_ID='"&EMP_ID&"' AND Approved='Yes' OR EMP_ID='"&EMP_ID&"' AND Approved = 'Partially Approved'"
I have the following script that will sum values in a column... How can I modify this script to sum values in a row.
Thanks in advance.
Script to sum values in column.
SQL2 = "SELECT SUM(Hours_Approved) AS Hours_Approved FROM TBLAGTREQUEST WHERE EMP_ID='"&EMP_ID&"' AND Approved='Yes' OR EMP_ID='"&EMP_ID&"' AND Approved = 'Partially Approved'"