Hello,
In short, I'm trying to write an IFF function that will look at my filed titled RelCaseNum and display a zero in a new column if RelCaseNum's value is zero, and if it's not zero, then I want the value stored within the field titled "CountVehiclesInRelCaseNum" to be displayed.
Below were my feeble attempts that have failed:
DesiredEnd-State:IIf([RelCaseNu]="0","0",[RelCasesVehicles])
DesiredEnd-State: IIf([RelCaseNu]="0","0","[RelCasesVehicles]")
DesiredEnd-State: IIf([RelCaseNu]="0","0",[nameofquery]![RelCasesVehicles])
If this helps, this is a sample of what the data currently looks like:
IncNo RelCaseNu RelCasesVehicles 2122415 0 1 2333515 215442200 0 21555515 0 1 6222915 69454583215 0 65111115 0 1 60099915 99666655 1 6666665 0 1 955555515 86543200 3 91111115 0 1
This is what I want it to look like:
IncNo RelCaseNu RelCasesVehicles DesiredEnd-State 2122415 0 1 0 2333515 215442200 0 0 21555515 0 1 0 6222915 69454583215 0 0 65111115 0 1 0 60099915 99666655 1 1 6666665 0 1 0 955555515 86543200 3 3 91111115 0 1 0