Hi,
I am trying to build a query where I need to count the games played by a group away and not at home. the fields away and home are drop down menus with either Y or N. First I opened the query wizard and I put the field groupId and away field in the wizard. But then if I want to count the amount of Ys in the Away table I always get the wrong number. I use a count function without a criteria. (putting in "Y" did not help)
is there any solution for this problem?
Thanks in advance,
Horst
I am trying to build a query where I need to count the games played by a group away and not at home. the fields away and home are drop down menus with either Y or N. First I opened the query wizard and I put the field groupId and away field in the wizard. But then if I want to count the amount of Ys in the Away table I always get the wrong number. I use a count function without a criteria. (putting in "Y" did not help)
is there any solution for this problem?
Thanks in advance,
Horst