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 Chriss Miller 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: *

  • Users: wvmbark
  • Order by date
  1. wvmbark

    Database for employee scheduling training, vacation, etc.

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

    Database for employee scheduling training, vacation, etc.

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Tables and Relationships for Employees / Supervisors

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

    Trim Left Totals Group By problem

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

    Trim Left Totals Group By problem

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

    Trim Left Totals Group By problem

    ok, now what??
  14. wvmbark

    Printing extra blank pages Tab Form

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

    Trim Left Totals Group By problem

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

    Training db table relationship layout help needed

    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!!!
  17. wvmbark

    Training db table relationship layout help needed

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

    Trim Left Totals Group By problem

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

    How do I create a many-to-many relationship

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

    Training db table relationship layout help needed

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

Part and Inventory Search

Back
Top