Jump to content
Sign in to follow this  
DenPub

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

Recommended Posts

Hi

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

Thanks

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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