1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to Create Employee's Monthly Production Report in MS Access

Discussion in 'MS Access' started by pavinm, Apr 29, 2009.

  1. pavinm

    pavinm New Member

    Joined:
    Apr 24, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    See I have in my DB 3 tables (log, staffdetails, and production)
    log contain, empid(Primaykey), login, logout, holidaylist fields)
    Staffdetails contains Staff name, empid(primaykey), userid(Primaykey), pass etc
    Production table conaing as you told.

    Once they login to db log table fields will update. Here I have created forms for staff details (For editing) and production.

    if they click production form, they will enter all the deatils. but here my doubt is perday may be they will enter 4 to 5 tasks and it will be come one production. I am not understanding the flow here.

    If they have not login means it read the log table (Holidaylist filed and if is matching with holdiay date then should take has holiday else next day it should give a pop message like yesterday you have not login, please update the form (reason they should give otherthan holiday).

    Thanks in advance.
    Pavitra
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    Moved to Access forum
     

Share This Page