Hi Larry,

>I don't think this is going to work. The subquery will get the latest effective date for the entire table. If all the prices change onthe same day, then that's okay; however, that may not be the case

Yeah, you're right, the subselect needs to look at the primary/foreign key also, doesn't it? It was more of an idea than a working snippet...that's what I get for not thinking it all the way through before starting to write (BG)