DataGrid
I have a datagrid in my form that contains coloumn of attendence of a perticular ID .what i want to do is to calculate total number of 'P' and 'A' in a textbox
Software/Hardware used:
Software/Hardware used:
ASKED:
May 13, 2008 7:50 AM
UPDATED:
May 17, 2008 5:35 PM
Answer Wiki:
Hello,
adjust and use the following queries to match your needs (change the YOURFILED to match your own).
<pre>
SELECT COUNT(YOURFIELD) AS COUNTPs WHERE YOURFIELD="P"
SELECT COUNT(YOURFIELD) AS COUNTAs WHERE YOURFIELD="A"
</pre>
Bye
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
