Results 1 to 4 of 4
  1. #1
    chanoc24 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    2

    Question Formula for form

    I have an simple attendance database like the one shown here:



    Date HrsAbsent(-) Balance HrsAccumulated(+)
    7/05/10 0 480 0
    7/12/10 8 472 0
    7/19/10 3 469 0
    7/26/10 0 480 12
    8/02/10 4 476 0
    8/26/10 2 480 12


    The maximum number in the Balance column cannot be more than 480 at any moment, but should count down like in the example above and then accumulate up to no more than 480. Every month the employee accumulates 12 hrs but the Balance can not be more than 480 in any month.

    How can this be handled in a form or query? Thanks in advance.

  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    in my opinion, what you should really do here is just keep a table with the hrs that an employees is absent on whatever dates that occurs. values that are calculated should never be stored in a table because it is not RAW date, which is what tables are meant for. Use forms, functions and formulas to create the accumulations per employee record when someone is browsing the right form

  3. #3
    chanoc24 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    2

    Formula for sick hours

    Thank you for taking your time to answer. However, this information is not intended for storage, just for knowing at the moment of the data entry the information requested about the sick hours balance of the employee. Anyway, which expression can be written in a query so this information is available when the query is opened, taking in account that 480 hrs is the maximum balance at any moment, and that from that moment on the balance goes down whenever sick hours are used and then can go up when accumulated to the maximum indicated? Thank you in advance for your help.

  4. #4
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    well, I don't think this data is normalized like it should be, so I would look at your database if you had it uploaded here, but beyond that there isn't really much else I can say about your problem. Perhaps someone else has better insight than me without looking at the file

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

Similar Threads

  1. Formula
    By hschrunk in forum Access
    Replies: 3
    Last Post: 05-18-2010, 01:40 PM
  2. Creating Formula In The Form
    By mastee in forum Access
    Replies: 3
    Last Post: 04-19-2010, 05:52 PM
  3. Help with formula for Query
    By goldie6175 in forum Queries
    Replies: 1
    Last Post: 02-18-2010, 11:29 AM
  4. formula on report??
    By dike969 in forum Access
    Replies: 0
    Last Post: 03-05-2007, 01:58 AM
  5. form formula to combine two fields
    By InvGrp in forum Forms
    Replies: 1
    Last Post: 10-20-2006, 12:10 PM

Tags for this Thread

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