denominator condition in an aggregate function

[Lifeseeker]

Hi,

Please help....I have this query, which is all based off of one table. It's so simple, but I can't seem to get it to work. It's a rate calculation.

SELECT Count([condition_numerator]) AS [A], (select count(condition_denominator) from tbl_Record) AS , [A]/ AS [C]
FROM tbl_Record
WHERE (((tbl_Record.condition_numerator) Like "*num") AND ((tbl_Record.denominator.condition)=1));

It runs, but won't give me the correct result. The denominator continues to pull the total number of patients in the database, so it's kind of skipping the condition_denominator parameter.

Any thoughts/direction is much appreciated. I know I am almost there, but really stuck....

Thank you

 

[pbaldy]

The subquery is independent, so it would need the same criteria.

 

[Lifeseeker]

The subquery is independent, so it would need the same criteria.

Hi, it worked.

Thanks

 

[pbaldy]

Happy to help.