Hello I working in a database in MS Access 2003 to know the Employee effort that dedicated to a project. I want when the user type in the subform the percent of dedication in the Field Effort:, select pending or current and click yes in one of the 3 option academic,calendar or summer field automatically send to the respective Totals that are divided into current or pending. I think that i need use the boolean if or else but i not know how.Please download my project a see where is the solution to PendingTotals and Current Totals.
I think that the example for one of the six totals syntax is something like this:
if Status = Pending
and academic = Yes
Then Pending_Academic Total = Effort
This vary by Proyect title.
Can download here:
I hope this help
http://www.4shared.com/file/11083901...se_effort.html