Results 1 to 2 of 2
  1. #1
    castellano is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    2

    Question Calculated and send to totals. Question

    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

  2. #2
    castellano is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    2

    Post


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-01-2009, 07:33 AM
  2. Beginner trying to send email with attachment
    By ahm in forum Programming
    Replies: 2
    Last Post: 03-24-2009, 08:51 PM
  3. calculated sum not working!
    By Linda Gamble in forum Access
    Replies: 1
    Last Post: 10-12-2007, 06:38 AM
  4. Net Send from a button on an Access form
    By Deb4995 in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 10:19 AM
  5. Day of Week Totals
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 03-18-2006, 07:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums