formula help

[Paintballlovr]

I've inherited this formula, which works, but I'm not sure how/if I can modify it. I would like the formula to use a criteria of a checkbox field being marked or not. Here is the current code:



=IIf([Forms]![Cashier Batch Control Ticket]![Check_RefNum] Is Null,"",(DSum("Amt_Split","tblMaster_835","((Check _RefNum='" & [Forms]![Cashier Batch Control Ticket]![Check_RefNum] & "') AND ((File_Split Like '*/hbremit*') AND (File_Split Like '*/TNMC835HB')))")))


As an example, there are two files in tblmaster_835 with the same Check_RefNum. The system marked one of them as DupConfirmed as it should, but I want the formula to not include DupConfirmed records in it's sum. The above formula is showing twice the value that should be displayed. I tried:

=IIf([Forms]![Cashier Batch Control Ticket]![Check_RefNum] Is Null,"",(DSum("Amt_Split","tblMaster_835","((Check _RefNum='" & [Forms]![Cashier Batch Control Ticket]![Check_RefNum] & "') AND ((File_Split Like '*/hbremit*') AND (File_Split Like '*/TNMC835HB' AND (DupConfirmed=’NO’))))")))

any ideas?

[Dal Jeanis]

I think you just missed the location of one right parenthesis:

=IIf([Forms]![Cashier Batch Control Ticket]![Check_RefNum] Is Null,"",(DSum("Amt_Split","tblMaster_835","((Check _RefNum='" & [Forms]![Cashier Batch Control Ticket]![Check_RefNum] & "') AND ((File_Split Like '*/hbremit*') AND (File_Split Like '*/TNMC835HB') AND (DupConfirmed=’NO’)))")))

[Paintballlovr]

Thank you very much. You beat me to the punch as I figured out my mistake and was coming in to close out my post.