Jump to content
Sign in to follow this  

Trying to use multi condition if statement to do a field count - not working

Recommended Posts


Have a sports db with a goals table and a players table goals are added to the goal field in the goalstable using the players jersey number. I'm trying to do a count of each players goal totals in the players table by using a multi condition if statement, both the goals table and the players table have team and division fields but its not working.

Here's the if statement:

If ((Division = Goals 2::Division) and (Team = Goals 2::Team) and (JerseyNumber = Goals 2::Goal) ; Count(Goals 2::Goal ); "" )

The key in the relationship is the goal field in the goals table and the jerseyNumber in the players table

What happens is the calculation gives all the goals for a given team to one player on that team.

Any help would be greatly appreciated


Share this post

Link to post
Share on other sites

If you have a relationship between Players and Goals, matching on PlayerID, then =

Count ( Goals 2::PlayerID )

calculated from the Players table, will return the count of related records only - no If() statement is required.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.