bracket error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

switch statement calculated field on a continuous form 1
switch calc 2 2
queryproblem ac2003 1
Access Counting records based on multiple age bracket and output to tabulated report 0
Append & Delete Sequence 3
remove brackets 4
Tournament Brackets 1
Will my table design cause future problems 9

Back
Top