Sum one filed based on its contsest

[BorisGomel]

Hello everybody,

I have a large table called nanfinal which consists 7 fileds:code,name, trns#,gross$,net$,commis$ and date. I created the form(frmnaninvoice) which has 5 text boxes. I need to calculated the total goss$ based on code in code filed, f.e if codes are 003 and 010 so text box named txtNSF would be populated by sum of gross where codes are 003 and 010 in code field. The break up like this :
code 003,010 txtNSF
Code 001,008,011 txtGross
Code 007,009 txtcost
Code 002 txtDirect
I placed a text box called textDate and put reference of it onto a query of the table nanfinal and placed a command button cmdadd so once user types date and click command button the adding sum will show up in corresponding text boxes accordingly the codes and date.
I need a help how to confugurate vb code into command button.

Thank you in advacne for help,

The Best Regards.

Boris

[June7]

Could use a Select Case structure in the Click event of the command button.

Review http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx

[BorisGomel]

Thnak you ,

That helped,

BorisGomel