How to make a totals field by combobox data

[john c hill]

I have created a form from my table, the form contains a Payment Field and a Combo box that contains 3 methods of payment i.e. Cash,Credit Card, Cheque.
I have created a totals field to sum the total payments, now i want another field to display Total Payments by Cash from my combo list. this i think is simple but i just can't get my head around it.

Thanks

[kiranghadge]

@john c hill
hi
you can check for payment mode then ....you can use selected indexchanged event of combobox in that u can add or display cash amount using textbox.text=combobox_selectedValues.tostring();

[john c hill]

Thank you for your reply but could you give me more detail as i dont really understand

[kiranghadge]

if u have any code for that send me i will tell you what to add in that
thanks

[MMcCarthy]

Hi John

To get back to your original question.

Assuming you are putting your total textboxes in the form footer and that total for the payments is

=sum([Payments])

then I think what you are looking for is to sum based on an IIf statement. Assuming your combo box is called cboPaymentType the following should work.

=Sum(IIf([cboPaymentType]='Cash',[Payment],0))

The logic of this being if the combo box is set to Cash then include the payment in the sum, otherwise include 0.

[john c hill]

works just fine, fantastic thanks so much
John

[MMcCarthy]

@john c hill
You are very welcome.

Mary