>How can I count the results of a qry based on a condition.
>
>Such as count(qry.sex) for qry.sex = 'female' , if I put this in an expression it is a syntax error?

The syntax is:
count for qry.sex = 'female'
-or-
count to lncount for qry.sex = 'female'