Find Max date of the year based other 2 fields(Name & Design)

[#1]

Hi All,

Herewith i have attached the QVW file which is developed using QV10 Personal Edition.

As there can be more than one Appraisal per year and Design(Trainer, Junior & Senior Teacher and Head Master), we only want to one Appraisal per year and this should be the lasted Appraisal per year.

Actual One                         :               Desired One

The script level solution should be most useful.

Thanks ....

Be Blessed with Happiness!!!

Ragards

Gangadharan Moorthy

[swuehl]

Hi Gangadharan,

I think there were only a

drop table Master;

too much. I checked both versions and they are working, Please check attached file. You could switch between two version by commenting in /out in script.

Regards,

Stefan