Thread: Sorting Issue
View Single Post
  #1   Report Post  
Sean DeBruler
 
Posts: n/a
Default Sorting Issue

I have a list of expriation dates that look like this for lets say 10 employees
A B C
MMD 5-25-07 Comments
First Aid 10-20-05 Comments
CPR 11-15-06 Comments
Passport 11-16-08 Comments

I want to sort each individule employee's information with the nearest
expriation date automaticly each time I access the file. I would also like
the employee's entire field to the top of the page i.e.

If Bob's field of information is at the bottom of the file but his CPR is
going to expire the soonest I want his entire field to move to the top of the
page. I don't even know if this is posible.