I have a form with fields [amount], [voucher] and a check box [bkd].
I want to sum the amounts for the vouchers one voucher number may be used several times due to credits. Is this possible?
PS I need the form in continuous view!!!
I have a form with fields [amount], [voucher] and a check box [bkd].
I want to sum the amounts for the vouchers one voucher number may be used several times due to credits. Is this possible?
PS I need the form in continuous view!!!
this is what i have but it sums up all the vouchers not just the ones duplicated please help
=DSum("[amount]","tbl_Inv_Values","[voucher] = [Voucher]")
I figured it out thies what i came up with
Sum of Voucher Total: DSum("[Amount]","tbl_Inv_Values","[voucher] = '" & [voucher] & "' ")
I was missing some spaces between quotation marks!!!