March 11th, 2003, 09:26 AM
Is there something wrong with this statement?
SELECT COUNT(applod.CAT) AS CATSR FROM applod WHERE applod.CAT LIKE '%SR%'
This colum has various values such as 1, 2, SR all I want is the number of records that have the value SR in them.
Also are you able to make calulations to recordsets, for example
producta = 20
productb = 30
((Sum (producta) + sum (productb) + sum (productc)) / (Sum (productc)))
to give me a percentage?
March 21st, 2003, 12:40 AM
Try the following
As for the maths on your results, you should be able to write ASP code via loops etc to add up your values, divide them, multiply them etc.
strquery="SELECT COUNT(applod.CAT) AS CATSR FROM applod WHERE applod.CAT=" & Checkvalue
How can I soar like an eagle when
I'm flying with turkey's?