Assign leanest value 1

[Chuku]

I have two types of processes like A and B.

say, If there are 5 processes totally

Sample data:
Process Type RecoveryTime
Proc1 A 4hours
Proc2 A 5days
Proc3 B 8hours
Proc4 B 3days
Proc5 A 12hours

I need to assign the leanest value i.e (4hours here) to a field called PRT. I should consider both the process types when i assign the leanest value. Process A and B are from different tables

How do I do that?

Thanks in advance.

 

[Chuku]

Lbass,
spacing was the issue.. got it now..

Thanks alot!! you are the BEST!!