Isolating Records When More Than One Row Exists....

I am trying to isolate a specific record (and a value within that record) where I have selected records based on a max(date). Some records come back duplicated because there are duplicate max dates.

For example:

SELECT

O.ID,
O.Date,
O.Amount = Case when o.Value in ('6','7','H','I') then 1 else 2 END
, O.Value


FROM Table O
WHERE o.Date = (

SELECT

MAX(O2.Date)
FROM Table O2
WHERE O2.ID = O.ID
)



The problem is that I get some ID's with Multiple records because they have 2 different O.Values. My table looks like this:


10/12/07 A $5.00
10/12/07 B $7.00
10/10/07 C $8.00

I want to find the Max(O.Date). Since there are two, then I want to find any records with that date that have an O.Value = B, if there isn't any, then I want any with an O.Value = A, if there isn't any of those, then any records with the O.Value = C. I basically need the O.Amount depending on the hierarchy of the O.Value.

I hope that makes sense. Any help would be appreciated.

- S