Trying to return latest date

[froggiebeckie]

I've run several searches and can't seem to find what I'm looking for, so here goes:

Have a table with several (maybe as many as 30) dates related to each employee, such as:

NAME-------CLASS 1-----CLASS 2----CLASS 3
J.Johnson.....10/16/05 ......12/17/05...12/25/05
S.Smith.........09/05/05......10/15/05

Not all employees will have entries in every class.

Need a query to result in most recent Date for each employee, such as:
--------------
J.Johnson......CLASS 3........12/25/05
S.Smith.........CLASS 2.......10/15/05

Any suggestions?

Thanks,
BeckieO

 

[shadow9449]

Beckie:

Are 'Class1', 'Class2' and so on the names of fields in the table?

If so, you have a basic design problem. If you search this forum to learn about normalization, then you'll understand that there are some real benefits in creating your tables using a better structure. For one, given your design, what if you have more classes than you've alloted for?

Another is that if you did use proper normalization, it would be a simple matter to pull up the most recent date for each employee using a query.

If you have trouble reading up on normalization, then feel free to ask



Good luck

SHADOW

 

[froggiebeckie]

Thanks for the quick response--I'll check out normalization.

 

[wkalo]

Hi
I Agree With shadow9449