Calculated and send to totals. Question

  • Thread starter Thread starter Joseph Pagan
  • Start date Start date
J

Joseph Pagan

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
 
i try to use this in a form no in a query.Is possible?..Please download my
project.Thanks
 
i try to use this in a form no in a query.Is possible?..Please download my
project.Thanks
Click to expand...

A Form is ordinarily based on a Query. Try it in the query and base your form
on that query.

I probably shouldn't speak for Alex but he, like all of us here, is an unpaid
volunteer donating his time on the newsgroup. It's more than a little bit rude
to demand that he download and fix your database for you.
 
Sorry but i from Puerto Rico and my first language is spanish. Many times I
have doubts as to reply in English so do not write much and I hope to
download the program to better understand my problem.I will try that the next
occasion to be more specific . No it was my intention in this way ented
 
Back
Top