Search results for query: *

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

Sounds easy enough... I'll post back if I run into any problems. Right now I'm trying to figure out another problem which I posted earlier today on the Queries forum... If it's not one thing it's another, egh? Thanks again, you've been a great help!!!

MajP - It's working now... it just took me some time to back track through your posts and figure out what I needed, what I didn't, and what order to put it all in. Thanks much for all your help!! Now I have to figure out the best way to create the input forms for the reference tables, etc...

I'm using the following expression to trim text preceeding "TECH REC" in a Text field: Left([ALERTtxt]![Description],InStr([ALERTtxt]![Description],"TECH REC")-1) I'd like to use this field with Totals selected - Group By, First, etc. but I get errors with each. If I use Expression it says...

PHV, What establishes the FK? Is only the fact that data from the PK field will be in there? Or, is it established by joins in the relationship window? Or, is it only really FK when joined in a query (I.e. for recordsource in the data entry form, etc.)? Thanks! Mike

MajP, "Where are you in the process?" Well, currently I'm trying to un-confuse myself and understand what I've got. I now understand the make-up and use of the cartesian products, the reference tables, and the outer joined queries for getting to my ultimate result (Which Controllers are...