Recent content by wvmbark

Majp, Regarding the ShiftCodes tables, how I take a table that has the "normal" weekly schedule and produce a result that shows that schedule spread over a 1 month, or 1 year interval? And, is having a different field for each weekday's schedule (as laid out in my first post) the best...

I'm trying to set up a database for scheduling and tracking employees' training, vacations, sick days, etc. Two things I'd really like to get out of the database... 1. Report where Rows would be employees and columns would be days "1/1/06", "1/2/06", etc. The values would be Start and End...

I'm not sure I fully understand you, yet. Are you suggesting xxxxxxxxxx My interpretation #1 xxxxxxxxxxx 2 tables (1) tblEmployees(EmpID, Name, EmpType, SupID, Address, other) and (2) tblSupCodes (SupCode, Description, SupID) where there is zero interaction/connectivity/links between...

MichaelRed, I'm not sure what your suggesting. Let's pretend that I'm in 4th grade. Could you explain a little further, possilby with an example of a table structure that will work for my application. Also, please address the following questions. (1) Should I have SupID only, or SupID and...

MichaelRed, I really do appreciate you hanging in there with me, but we're not on the same page yet.... Here's the breakdown of my organization (we call it a department, but it's actually several small departments within on Division). Admins, Analysts, and Controllers - bottom-tier employees...

MichaelRed, but this does not represent the single table with a normal (e.g. 1 supervisor to many employees) relationship. You have: EmpID EmpType SupID SupCode 2 Controller 13 COO1 3 Controller 13 COO2 Which shows employees # 2 & 3...

No!! Every employee does have only 1 supervisor... SupCode "COO1" identifies a work shift and a particular work group on that shift. Everybody on that shift and in that group is assigned a SupCode "C001". tblSupCodes identifies who the supervisor for employees assigned SupCode "C001" is...

Please excuse the mess... I've yet to figure out how to post columns. tblEmployees EmpID EmpType SupID SupCode 1 Analyst 12 2 Controller 13 COO1 3 Controller 13 COO2 4 Controller 14 COO3 5 Controller 15 COO4 6 Controller 15 COO5 7 Controller 16 COO6 8 Controller 17 COO7 9...

My tblEmployees SupID does use the EmpID of the Supervisor and data input works great using the self-join method I've seen in several posts here. I assume that if I went a step further and added Cascade Updates/Deletes, and if a supervisor's position is replaced by another employee, I could...

I'm hoping someone can help me determine the best way to set up my tables and relationships for an Employee database (contact info, training, work schedules, etc.) I'm currently stuck on the set-up and proper relationship properties for the following two tables... tblEmployees EmpID -PK...

PH, "why an aggregate query without aggregate function ?" - I was eliminating fields from the query to determine where my problem was. The aggregate function is actually being used to capture the most current ActionDate from a details table... SELECT ALERTtxt.[A/C] AS Tail, ALERTtxt.Alert...

That's it! Every record should contain TECH REC, but it could be miss-keyed (as it was in this case). Would I use an IIf function to remedy this? If so, could you show me how I'd set up the evaluate part of the expression? If it doesn't contain TECH REC, then I want to leave as is. Thanks!! Mike

ok, now what??

Yes, if the width of the form is greater than the distance between your page margins, it will carry over to additional pages. You can extend the page margins or change to landscape format using Page Setup in the File menu. Mike

SELECT ALERTtxt.[A/C] AS Tail, ALERTtxt.Alert, ALERTtxt.ATA, ALERTtxt.Status, Left(ALERTtxt!Description,InStr(ALERTtxt!Description,"TECH REC")-1) AS [Desc] FROM (ALERTtxt INNER JOIN [Alert tbl] ON ALERTtxt.Alert = [Alert tbl].Alert) INNER JOIN [Alert compliance tbl] ON [Alert tbl].Alert = [Alert...