Search results

TY for your help I see where I went wrong. I am currenlty setting up another query for the evaluation date. However, I have tried it several ways and found that it ends up placing my basic, proficient, Master columns into each separate qualdesc. Each qual should have basic, proficient, master...

I take that back here it is. It is a possibility that I could have some of the data mixed up. I will check back later on to see what I have messed up on. I am running Access 2000

The link here does not allow me to send it with all my documentation because of the size. but I can try again.

When I am creating a query this is the message that I am receiving The wizard is unable to open your query in Datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in Deisgn view. I click ok and then try to view it in datasheet...

Yes it is all ID have number in the data type field box. This is just getting frusterating for me and I know I can get it. I have been able to create the employee/group id box but when I try to create the next query is when it pops up with the error. I have also added data to groups, employee...

I am experimenting with queries although I know that I am probably not ready for them but I keep getting errors that says something like mismatch and it brings be to the query design screen. Why

ok these fields then stay empty until the data has been entered. I have filled in the rest of the tables with data so I think then if I am correct I move onto creating the queries.

tblEmpJobQual -pkEmpJobQualID primary key, autonumber -fkEmpJobsID foreign key to tblEmpJobs -fkJobQualsID foreign key to tblJobQuals Why then do I have two different number of records for the EmpJobsID and JobQualsID. Shouldn't they have the same number of records.

I think I know what I did the table mentioned above is for the basic requirements for each job I ended up just putting them under the Qual Desc to make it easier for myself. Now wouldn't I just delete this table since I won't be using it?

I have another question when I am working on the tblEmpJobQual I have noticed that when I enter the data in for EmpJobsID I have a total number of records equaling 281 and for the JobQualsID I have total number of records equaling 511. Was this one mismarked and should be something else?

I just ran across it there are so many I was way off with my original database. Thanks for your quick response.

I do have one additional question while I am working on the tables themselves I noticed that the QualDesc isn't linked to the Job Title why is this done that way? I have only 9 group names and 35 Job Titles while several of these job titles fall under the groupTitles. Couldn't I create a new...

I am going to work on this through the weekend. If I have any more questions I will ask next week. Thank you for your help.

Thanks so when I get to the step of creating the actual form how will I know what jobdesc goes with each job title since it is all together in one file without a title next to it to help place it in the right location.

For each job Title they cannot be in each department however some of the job descriptions can be. Our company is divided up into several groups such as Quality - Engineering - Production - Purchasing - Management under each of these are a listing of job titles the only one that share a job...

What this database is is going to be a huge training matrix that will allow the administrator to keep track of all employees in regards to departmental training, hiring date, termination date, qualifications such as SQR, DSQR and the date of attendance and when next one is due, eye exams, stamps...

for my qualifications table it would be something like this: tbleQual -pkQualID -QualTitle -QualDate I do have one other question for the jobtable. Since I have several job descriptions under one Job Title once I setup the form it should show all these plus all me join this table with the...

So what I am doing is having too much info in the tables. Since you are using programming language I will have to convert the database into vb then.

The Basic, Proficient, and Master Dates and dates that the individual is quaified. This database is setup to allow the adiministrator to edit data that is stored for each employee such as qualifications, school and any other information needed. However, I just found out that I am running...

Table 1= First Name, Last Name, Job Title = Text Act Date, Term Date = Date check box for Union and Active Clock Number = Number Table 2 = Clock ID = Number Job Title = Text Descr = Memo Basic, Proficient, Master = Dates I have a relationship between the Clock ID and Clock Number and one...