Noero
asked on
Add Sum to an item (see file)
Hello guys
In a formular, frmCourseMain, I just want to add a textbox (SUM in red in the file) which contains the sum of the fees of the student registered for the course chosen.
I made a simple request SumFeesOfCourse, and I dont know how to link this with the textbox in order to screen a correct result.
I think my understanding of how to link is not proper...
Thanks in advance for explanation!
example.mdb
In a formular, frmCourseMain, I just want to add a textbox (SUM in red in the file) which contains the sum of the fees of the student registered for the course chosen.
I made a simple request SumFeesOfCourse, and I dont know how to link this with the textbox in order to screen a correct result.
I think my understanding of how to link is not proper...
Thanks in advance for explanation!
example.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Quick, Clear, Efficient: Thank you!
This will give you the sum for the CourseID of the current record on your main form:
=DLookUp("SommeDeFees","Su