Search results

I may not of title this wright, but this is what Im trying to do. I have a tblCompany, tblEmployee, tblTraining, tblRoster. The tblRoster is the join table between employees and training. I want to beable to select all of the empolyees that attended the training at once and give them credit for...

Well I have; tblCompany (CompanyID, CompanyName, ) tblEmployee (EmployeeID(SSN), fk_CompanyID, Name, JobPosition, AttendedTraining) tblTaskList (TaskListID, TaskTitle, TaskCondition, TaskStandards, TaskRef, MaxDAys) tblTraining (join table for tbltaskList and tblEmployee m:m relationship)...

I have to track companies, employees and their training they have to attend depending on what category they fall in. (CAT I, CAT II...) Company can have many employees and employees can only have one company. A Company can only fall into one Category, but an employ can fall into its own Category...

Thanks I will look at that. I did figure it out though. Eval ([Type] in ("A","B")) worked. Thank you for your time.

I have a problem Im hopeing someone can help me with. On a form I have several fields that look like this; type , day, night. Now if (type = A, or B than day highlights orange). How would I write the expresion in the conditional Formating form for the day field.

Ok thank you I have the first part completed and it works. It gives me the over all numbers, but now I need it broken down buy departments. any Ideas? I have a CompanyTable, departmentTable, and EmployTable they are all part of the same form. I am trying to get the department numbers on the...

tableB is an one too many with tableA One Item in tableB can have many items in tableA. I need to count how many itemA in in tableA is related to itemB in tableB. How many employees dose companyB have? I am trying to do this on a form. I have a company form with a sub form from the employees...

I need help with this, I have dateA and dateB. I need to seee dateB light up when its outside a 6 mth window of dateA, dateB happens before dateA. dateA dateB 1jan12 1june11 dateB is 7 mts from dateA which is outside the 6 mt window so it should be red. Any thoughts on...

oK I have a UNIT_Table, Soliders_Table, and a Training_Table. UNIT_Table: UnitID, Unit_Name, Unit_Cat, 1, 123rd IN, CAT III 2, 456th IN, CAT II Soldiers_Table UnitID, SoldiersID, L_Name, F_Name, M_Name, AN, SSN, Smith, Joe, D., Again the next table sturcture...

I have a field called Category the records in that field are CAT I, CAT II, CAT III, CAT IV. There are 10 Training events. So CAT I requires a trainee to complete training events 1-5. CAT II requires a trainee to complete all of CAT I training events plus 6-8 CAT III requires a trainee to...

Ok I have run into a road block, I have trainees that fall into 4 different categories. Each category builds on one another. What I mean is cat_1 was training 1,2,3 out of 10 events, cat_2 has 1,2,3,4,5,6 out of 10, cat_3 has all of cat_1 and cat_2 pulse 7,8. Any way the expression I used above...

vbaInet, and everyone else that helped me Thank You. I understand what I need to do now.

This DoLookup I ahve the first part working but dont understand the DoLookup.

Ok I have the first part working can get help with DLOOKUP function part.

I agree it would make more sense to re-structure at an early stage in the development of the database. But there's a catch, I did not develop the database and its not in the early stages. I guess the reports have really driven the structure of this database. I am working on a database that will...

Thank you for your quick responce. I dont know if that will work, the data is arranged, I think wrong. This is what I have Table A with AID and table B with BID&AID. It is a one to one relationship, One record in A has one record in B. But BID has 10 training task to complete befor AID can...

Hello all, I have a situation where I would like to have a check box turn on when training is complete. What I have is collective training events with several training requirement to be completed. I would like the competed check box to turn on after all training requirement have been meet for...

Thank you for your help. I ended up putting a expression in my query’s using the expression you showed me. I then adding unbounded text box to the reports and forms and I adjusted the input mask with 0\-0000;0;_ and that worked. :)

I tryed it and I get 00001 not 0-0001. I am going to look at the properties and see if I can set the format like you can on the tables for SSN. Thank you again !

Ok I have taken (dateadd("m",6,[trained_date])>[deployment_date]) and added it to the expression under the conditional formating pop up tool. I dont know what i have done wrong but it is not working. I am a begener so I may have missed a step. Thanks for your help.