Hi all,

I'm quite a new Crystal user and this is the first time I've posted so please go easy! You've already solved many of my teething issues in previous posts so thanks!

I have data that looks like this:

Table 1: <NameID> <Name>

Table 2: <NameID>, <RatingID1>, <RatingDate1>, <Rating1>, <RatingID2>, <RatingDate2>, <Rating2>

I need to get Crystal to select the record from table 2 that has the most recent date (based on the RatingsDate field), and then display the relevant Rating field on the Report based on this most recent date.

Can this be done. I have been trying to use the MAX function in the record select expert but have been receiving errors that this must be evaluated later?

Thanks in advance for any ideas you can pass to me.

K