need help
I've folowing table
(assume that there is no constraint on table)
department
deptno deptname salary
+100 Test1 10000+
+200 Test2 20000+
+300 Test3 30000+
+100 Test1 15000+
+100 Test1 20000+
+200 Test2 23000+
+300 Test3 3300+
i've a form (name sample) which has following field
deptno, deptname,salary
This form(sample) displays data from department table
Now my requirement is that i need to display the data from department such that total salary corresponding to department number 100 should be displayed in salary field i.e.
deptno deptname salary
+100 Test1 45000+
+200 Test2 20000+
+300 Test3 30000+
+200 Test2 23000+
+300 Test3 3300+
It means i've to display total salary corresponding to a particular department id( say 100).
how can i do that?
Please help me.
i'll appricate any kind of help.