March 11th, 2003, 09:26 AM
Join Date: Mar 2003
Time spent in forums: 21 h 18 m 21 sec
Reputation Power: 11
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?