Counting records in a row

[YoelBenYossef]

Hi there,
I'm working on a database with legacy data. I want to be able to tell how many records in a row answer a boolean criteria. Is there any way to do that?

Eric

 

[PHV]

Something like this (SQL code) ?
SELECT Count(*)
FROM yourTable
WHERE BooleanCriteria = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[YoelBenYossef]

Actually, the trick is that I need to know how many in order are true ... It's a little rough. I'm using legacy data from an old medical recording machine. I need to know how long an even lasts ...

Thanks
Eric

 

[PHV]

Please, read carefully this: FAQ181-2886