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

Hi,
I think you can try to use IIF() function in underlying query

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"Joseph Pagan" <(E-Mail Removed)> wrote in message
news:CDB3E776-74FD-4F25-B439-(E-Mail Removed)...
> 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

"Alex Dybenko" wrote:

> Hi,
> I think you can try to use IIF() function in underlying query
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
>
> "Joseph Pagan" <(E-Mail Removed)> wrote in message
> news:CDB3E776-74FD-4F25-B439-(E-Mail Removed)...
> > 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
> >
>

On Wed, 10 Jun 2009 14:06:01 -0700, Joseph Pagan
<(E-Mail Removed)> wrote:

>i try to use this in a form no in a query.Is possible?..Please download my
>project.Thanks

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.
--

John W. Vinson [MVP]

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

"John W. Vinson" wrote:

> On Wed, 10 Jun 2009 14:06:01 -0700, Joseph Pagan
> <(E-Mail Removed)> wrote:
>
> >i try to use this in a form no in a query.Is possible?..Please download my
> >project.Thanks
>
> 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.
> --
>
> John W. Vinson [MVP]
>

Closing... For continue go here:
http://www.mrexcel.com/forum/showthr...17#post1967117

"Joseph Pagan" wrote:

> 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
>
> "John W. Vinson" wrote:
>
> > On Wed, 10 Jun 2009 14:06:01 -0700, Joseph Pagan
> > <(E-Mail Removed)> wrote:
> >
> > >i try to use this in a form no in a query.Is possible?..Please download my
> > >project.Thanks
> >
> > 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.
> > --
> >
> > John W. Vinson [MVP]
> >

"Joseph Pagan" wrote:

>closing and linking to: http://www.mrexcel.com/forum/showthread.php?t=393635
>
> "Joseph Pagan" wrote:
>
> > 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
> >
> > "John W. Vinson" wrote:
> >
> > > On Wed, 10 Jun 2009 14:06:01 -0700, Joseph Pagan
> > > <(E-Mail Removed)> wrote:
> > >
> > > >i try to use this in a form no in a query.Is possible?..Please download my
> > > >project.Thanks
> > >
> > > 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.
> > > --
> > >
> > > John W. Vinson [MVP]
> > >

http://forums.aspfree.com/microsoft-...on-283961.html