MAX Data

[kwooten]

I need to find the Max of a number i assign an employee and show only that field... how do i do this?

I have 3 tables.. 1 for the employee data, 1 for the education level, and 1 that gives me a code and new description for the education level.. For instance an employee has a bachelors in science and a masters.. I assign the bachelors a 1 and MBA a 2. Since there is more than one masters i have masters renamed in the table with the 2 as "Masters"..

How do i create a formula that will give me the highest level of education only?

[orange]

Perhaps you should show us a picture of your tables and relationships.

I suggest your tables should look something like:

EMPLOYEE
Id (primary Key)
FirstName
LastName
other info specific to an Employee

EMPLOYEE_EDUCATION
EmployeeId (FK to EMPLOYEE)
EducationId (FK to EDUCATION_LEVEL_LOOKUP)
Education_DisciplineID (FK) to EDUCATION_DISCIPLINE)

EDUCATION_LEVEL_LOOKUP
EducationId (PK)
EducationDescription

EDUCATION_DISCIPLINE
EducationDisciplineID (PK)
EducationDisciplineDescription

Typical Values in EDUCATION_LEVEL_LOOKUP table

1 Bachelor
2 Master
3 PhD


Typical Values in EDUCATION_DISCIPLINE

1 General Science
2 Electrical Engineering
3 Biology
4 Environmental Studies
5 Business Administration
6 Mathematics
....

If Employee John Doe (Id 1005) has several degrees, then he would have a record for each degree in the EMPLOYEE_EDUCATION table

1005 1 2 Bachelor Electrical Engineering
1005 2 5 Master Business Administration
1005 2 6 Master Mathematics

[kwooten]

CPO_EMP_ALL is the employee data, HUMANIC_EDUCATION is the table with the education data.. I am using edlevel. EDUCATION DATA REFERENCE is the table that reassigns the edlevel or degree type to the consolidated degree type.. I am not working with major.