I need help in creating a loop through a recordset.
I have data containing information about event meals. Each event has a start date, end date, first meal, first meal date, last meal and last meal date. I need to loop through the data and create a record in a table for each date that a meal should be prepared in the following format:
event#, meal date, # for breakfast, # for lunch, # for dinner
So, for example, event #1 starts on 1/1/2018, the first meal is lunch on 1/1/2018 and the last meal is dinner on 1/3/2018 and has 8 people attending.
The records created should be as follows:
1, 1/1/2018, 0, 8, 8
1, 1/2/2018, 8, 8, 8
1, 1/3/2018, 8, 8, 8
Thank you
I have data containing information about event meals. Each event has a start date, end date, first meal, first meal date, last meal and last meal date. I need to loop through the data and create a record in a table for each date that a meal should be prepared in the following format:
event#, meal date, # for breakfast, # for lunch, # for dinner
So, for example, event #1 starts on 1/1/2018, the first meal is lunch on 1/1/2018 and the last meal is dinner on 1/3/2018 and has 8 people attending.
The records created should be as follows:
1, 1/1/2018, 0, 8, 8
1, 1/2/2018, 8, 8, 8
1, 1/3/2018, 8, 8, 8
Thank you