Hi everyone. I am really at my wits end with this because I am not an access person at all, I just kind of got stuck with this task. I'm hoping someone can help. So we have a field in a report, and currently, there is a text box with a control source of
=IIf([Flag1]="Capital",[Reserve]-Sum([Text52]),"")
They want me to add to it, where if [Text106]="0",[Reserve]-[Text52], otherwise it's [Text106]="0",[Reserve]-[Text106]
I am able to do this second part OK with
=IIf([Text106]="0",[Reserve]-[Text52],[Reserve]-[Text106])
But then I lose the [Flag1]="Capital" part.
Can you tell I have no idea what I'm doing?? Ha ha. It would be awesome if someone could help me out or point me in the right direction.....Thanks!
=IIf([Flag1]="Capital",[Reserve]-Sum([Text52]),"")
They want me to add to it, where if [Text106]="0",[Reserve]-[Text52], otherwise it's [Text106]="0",[Reserve]-[Text106]
I am able to do this second part OK with
=IIf([Text106]="0",[Reserve]-[Text52],[Reserve]-[Text106])
But then I lose the [Flag1]="Capital" part.
Can you tell I have no idea what I'm doing?? Ha ha. It would be awesome if someone could help me out or point me in the right direction.....Thanks!
