Results 1 to 4 of 4
  1. #1
    Beltramo64 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Dec 2017
    Posts
    12

    How to create an expression in a form

    I am new to access and need some assistance, with creating an expression in a form under Conditional format that would tell me when a person has a total of 40 hours scheduled for a particular work week. The fields that are being inputted are the weekly hours per person per week. ie... 47 as it associates with a person and lets you know when you've summed up to 40 hours for each person per week.



    Click image for larger version. 

Name:	Capture.JPG 
Views:	10 
Size:	27.0 KB 
ID:	31481

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the text box put an = then your formula (the name of the textboxs ,not the field, but sometimes they can be the same name)

    =txt1 + txt2+ txt3

  3. #3
    Beltramo64 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Dec 2017
    Posts
    12
    I don't think I clarified my question correctly, this is a form that as I Input the hours for a particular employee, I want a formula (Conditional formatting) that tells me when the sum of a each week (ie.. 47), for a specific person has equaled the 40 hours for that person so you can not input extra hours as you work through employee list. This will be extremely helpful, to prevent duplications

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    my text still holds:
    the total hrs: txtTotal =txt1 + txt2+ txt3...
    if the txtTotal = 40 then it must stop for RegHrs.
    the remainder goes to OvtHrs.

    Then if no Overtime exists then
    OvtHrs remains zero but warn the user, no more entries.
    Is this the scenario?


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

Similar Threads

  1. Replies: 7
    Last Post: 12-03-2015, 04:14 PM
  2. Replies: 1
    Last Post: 01-29-2015, 01:30 PM
  3. Replies: 3
    Last Post: 09-13-2013, 04:17 PM
  4. Replies: 3
    Last Post: 12-02-2012, 12:59 AM
  5. Replies: 7
    Last Post: 12-30-2009, 11:03 AM

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