>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?

I assume you mean a SQL query. The following would work:

SELECT *;
  FROM Qry;
  WHERE Sex = 'female';
  INTO CURSOR foo
lncount = _TALLY

If not a query:

COUNT FOR Qry.Sex = 'female' TO lncount

hth,