Thanks. Sorry I should have uploaded code better.

Here is the table:

StudentIDForenamesSurnameTrainingProviderStartDateEndDatePlannedHoursActualHoursIncludeInStudyProgrammePMStudentIDCourseIDCourseCode

12345678FirstnameSurnameAP109/02/2015 00:0013/02/2015 00:00NULL11159139XDMEDIA

12345678FirstnameSurnameAP109/02/2015 00:0013/02/2015 00:00NULL111591102TUT

12345678FirstnameSurnameS3P16/02/2015 00:0020/02/2015 00:0035NULL159139XDMEDIA

12345678FirstnameSurnameS3P16/02/2015 00:0020/02/2015 00:0035NULL1591102TUT

12345678FirstnameSurnameTCCSL16/02/2015 00:0020/02/2015 00:003535159139XDMEDIA

12345678FirstnameSurnameTCCSL16/02/2015 00:0020/02/2015 00:0035351591102TUT

12345678FirstnameSurnameWS12/11/2014 00:0015/11/2014 00:00NULL37159139XDMEDIA

12345678FirstnameSurnameWS12/11/2014 00:0015/11/2014 00:00NULL371591102TUT

OK thanks - I'll have to have a read up on how to create the history table.

Hi,

Thanks for responding. I suppose in my mind I'd like to be able to see the changes historically. So if I want to report on how many applications were in...