Hi Sir
I habe a table MASTER in which four fields are there Course_Code, Ind_ID, Date_from and Date_To:
I want to run a query to append the recorde in table SESSION in which four field s are there: Course Code, Ind_ID and DOT (Date of Training)
How can I append recorde for each day of training . For example if Date_from is 08/Feb/24 and Date_to is 10/Feb/24. I want for each day i.. 8,9 and 10 each individual ID with course code should be added in the SESSION Table.
I habe a table MASTER in which four fields are there Course_Code, Ind_ID, Date_from and Date_To:
I want to run a query to append the recorde in table SESSION in which four field s are there: Course Code, Ind_ID and DOT (Date of Training)
How can I append recorde for each day of training . For example if Date_from is 08/Feb/24 and Date_to is 10/Feb/24. I want for each day i.. 8,9 and 10 each individual ID with course code should be added in the SESSION Table.