CountParties: Count([tblEvaluations!PartyTypeID]=1 And
[TableEvaluations!PeopleTypeID]=1)+Count([TblEvaluations!PartyType]=2 And
[TblEvaluations!PeopleTypeID]=1)

It doesn't like my brackets which appear to be okay to me. I just want to
know the
related records that have PartyType 1 & 2 and also the People Type of 1.
thanks,
--
Janis

Now there is no bracket error but it says:
You tried to execute a query that does not include the expression as part of
an aggregate function?
CountParties: Count(tblEvaluations!PartyTypeID=1 And
TableEvaluations!PeopleTypeID=1)+Count(TblEvaluations!PartyType=2 And
TblEvaluations!PeopleTypeID=1)
tia,
--
Janis


"FilemakerPro_Developer" wrote:

> CountParties: Count([tblEvaluations!PartyTypeID]=1 And
> [TableEvaluations!PeopleTypeID]=1)+Count([TblEvaluations!PartyType]=2 And
> [TblEvaluations!PeopleTypeID]=1)
>
> It doesn't like my brackets which appear to be okay to me. I just want to
> know the
> related records that have PartyType 1 & 2 and also the People Type of 1.
> thanks,
> --
> Janis