Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ddecker3

    Employee Attendance Database

    Ok current table structures now: MAIN (not a good name for a table probally) id rate name muster comments MUSTER musterid employeeid musterdate atwork shift comment SHOPS shopid shop TBLSHOPEMPLOYEE id employeeid shopid CURRENT RELATIONSHIP SETUP MAIN-ID to tblShopEmployee-EmployeeID...
  2. ddecker3

    Employee Attendance Database

    Also shifts switch on a regular basis, so shouldnt it be mainly in the attendance table?
  3. ddecker3

    Employee Attendance Database

    SHOP info is just 120 220 130 13A Each shop as anywhere from 3-12 people in it. Rank is like IT1 IT2 AM2 Rank can be the same for anyone (multiple AM2's, ect) I have not put into the work on who is the Leader of each shop, to much "not needed" work. I have tried to do what lespaul said...
  4. ddecker3

    Employee Attendance Database

    Ok this is what I have: For one Shop now INSERT INTO Muster ( ID, AtWork, Comment, [DX/NX], MusterDate ) SELECT MAIN.ID, MAIN.STATUS, MAIN.COMMENT, MAIN.[DX/NX], Forms![ALL]!MusterDate AS TodaysDate FROM MAIN WHERE Main.SHOP=Forms![120SUB]!SHOP; But now it pops a small window when I run the...
  5. ddecker3

    Employee Attendance Database

    Would I need mutiple queries then? I just created mutiple queries and call them? or can you build/create them on the fly? I dont know which is easier/better Decker
  6. ddecker3

    Employee Attendance Database

    What I wanted was a way to keep an attendance report for everyday. After reading around the above way is the way I found to work. But it was kind of hard to checkbox everyone here (148users) everyday, so I tried breaking it down to each shop/class. From there, there is also DX/NX...
  7. ddecker3

    Employee Attendance Database

    I thought it was supposed to add a new entry for each person for each day. I needed a way to keep an accurate attendance everday with some extra info (DX/NX), comments.
  8. ddecker3

    Employee Attendance Database

    Here is the append query that I run: INSERT INTO Muster ( ID, AtWork, Comment, [DX/NX], MusterDate ) SELECT MAIN.ID, MAIN.STATUS, MAIN.COMMENT, MAIN.[DX/NX], Forms![ALL]!MusterDate AS TodaysDate FROM MAIN;
  9. ddecker3

    Employee Attendance Database

    How do I post the SQL? I am kind of new at using Access/ Thanks David
  10. ddecker3

    Employee Attendance Database

    Ok, so I have an attendance database with 3 tables right now TABLE NAMES AND FIELDS Main - Fields (ID, Rank, Name, Shop, Status, DX/NX, Comment) Muster - Fields (MusterID, ID, Musterdate, Atwork, DX,NX, Comment) Shop - Fields (120, 220, 050, ect) I am using and AppendQuery from the main, to...
  11. ddecker3

    Filter a query based off another query

    Is it possible to set the critiera for a query based off another query? I have 2 tables: employee and quals I know how to pull from both tables to say which employee are qualed. But how do I pull all employees that are not qualed. Basically if they are on both lists how do I not pull them...
  12. ddecker3

    Watchbill/Sort of employee shift scheduler advice

    Thats correct the watchs on the weekend are those. Yes I am still very interested in trying to get something working, its fun trying to learn things as I go along also.
  13. ddecker3

    Watchbill/Sort of employee shift scheduler advice

    Let see there are two watch's (positions). ASDO and Duty Driver. Weekdays ASDO has two shift. Duty Driver has 3 shifts. Weekends the both have 3 shifts. Hope that explains it all.
  14. ddecker3

    Watchbill/Sort of employee shift scheduler advice

    Ok, A Watchbill is like an employee schedule for a day. We have 20 employee's that can work each day in a four day rotation. But we only need 5 people during the work week, and 6 people on the weekend. There is 2 watches(jobs) that are eight hour shifts each. One is called ASDO, and the...
  15. ddecker3

    Watchbill/Sort of employee shift scheduler advice

    Hello, I am trying to figure out a way to make an automated watchbill. ok brief descp. for the non military. We are in 4 sections. Each section has about 20 people. We stand 2 differant watchs in 8 hour intervals. So say Monday Duty Section 1 has it, so they need 6 watchstanders total. 3...

Part and Inventory Search

Back
Top