Count 2 Numbers from one table
Hello Guys , this is what i am looking for
I have one table called invoices with drop downmenu, DrDown values are Invoiced paid, Invoiced Notpaid , Quotation, What i prefer to copunt all this 3 Sepratly.
For instance , lets say we have 5 invoices.,
invoice no 1 total 10 (Invoiced)
invoice no 1 total 20 (Invoiced)
invoice no 1 total 30 (Quotation)
So what should be the endresult 30 invoices and 30 Pending /quotation
thanks in advanced.
what i am looking for to filter those values and count the total sepratly . what function can i use to acomplish this task ?