calculated controls coding

  • 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
 
Joseph,
Most of us here will not download an Access application from an unknown
source. You will most likely get an answer if you just describe your problem
in detail.
 
What i want?
I want that 6 textbox 3 named Pending and the other 3 Current do a calculate
using a code.
What is the calculation that i want.?
I need something like if,and, then:
Here is the example i do not know if is this the way;for two textbox one in
the Pending Totals and the other on Current Totals.

if status="pending"
and calendar = yes
then the textbox = the percent of effort
in another textbox coding.
if status = "current"
and calendar = yes
then the textbox below currents = percent of effort.

I hope this help.
 
You don't show what the caluclation should be, but as to how to do it in the
text box, put something like this in each of the text box control source
properties:

To show the Pending amounts:

=IIf([status] = "pending", math goes here, Null)

To show the Current amounts:

=IIf([status] = "current", math goes here, Null)

This will cause the text boxes not involved to show as empty
 
I want to sum the effort of the employee for the different project they have,
i need to put in the calculation the effort,status and
months(Academic,Calendar,Summer)to classified.
Ihope this help. The url that i put is the other reply is wrong here is the
valid source sorry:
http://forums.aspfree.com/microsoft...end-to-totals-question-283961.html#post701473

Klatuu said:
You don't show what the caluclation should be, but as to how to do it in the
text box, put something like this in each of the text box control source
properties:

To show the Pending amounts:

=IIf([status] = "pending", math goes here, Null)

To show the Current amounts:

=IIf([status] = "current", math goes here, Null)

This will cause the text boxes not involved to show as empty
--
Dave Hargis, Microsoft Access MVP


Joseph Pagan said:
What i want?
I want that 6 textbox 3 named Pending and the other 3 Current do a calculate
using a code.
What is the calculation that i want.?
I need something like if,and, then:
Here is the example i do not know if is this the way;for two textbox one in
the Pending Totals and the other on Current Totals.

if status="pending"
and calendar = yes
then the textbox = the percent of effort
in another textbox coding.
if status = "current"
and calendar = yes
then the textbox below currents = percent of effort.

I hope this help.
Click to expand...
Click to expand...
 
Back
Top