Sum By Clients

[BorisGomel]

Hello ,

I got new task from my boss and I need help to solve this . I have a large form( 25000 records) which consists 4 fileds -banks, accounts ,expenses, and amounts .I need to able to select the banks via list box and the total amount of checks that have been issued to that bank should be calculated on the form .I created the list box that listed all banks and now I need to code if I select the bank in the lsit box the total amount will be show up in the text box "TotalAmount" accordingly the bank I have selceted .I am not expert in coding in VB -help will be greatly apprected .
Thank you ,
Best Regards.

[Cheshire101]

Ok... I think understand what you are asking...
If you want the total amount issued to the bank then you can use like this

UnboundField = DSum("$$Field","TableName","BankName='" & Me.BankNameFieldonForm & "'")

You can then set the format of the field to Currency

[BorisGomel]

Thank you so much , works beautifully .
Will mark this as solved