Search results for query: *

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...

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

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...

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...

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

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...

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.

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;

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

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...

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...

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.

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.

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...

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...