Hi all,
I have a form I build in access db with a control source where I want to write a formula in that control source based on a table called " Entity master"
The table has the following columns: child entity, parent entity, country of child, country of parent, and amounts
I want the if statement to say the following. If(EntityMaster.CountryofChild) = "US" AND if(entitymaster.CountryofParent = "US" then sum up only the negative amounts in the amounts columns.
Here is what I have below:
Code:
IIF([EntityMaster]).[ParentofJurisdictions]="United States",IIF([EntityMaster].[ChildOfJurisdiction]="United States",SUM([EntityMaster].[Amounts]))))
How do I specific to only sum negative amounts? also i'm getting a #name? error message on the form
.
Any help is appreciated, thank you.