From A Range to Per-Day Entry

[vetabz]

Please see the image below for the description of my concern.

[orange]

I suggest you step back and tell us what you are trying to do in simple business terms.
What business is involved?
What does fld_A really mean? Could it be range_Name?

[vetabz]

Okay, I want to track employees and their movements between who's managers/supervisor they've been with for a certain period and even inter-department movements.

These are thousands of employees, and each movement is associated with a date range. I wanted to extract those changes into a per-day basis and since this is MS Access I'm dealing with, I suppose the most efficient approach is via SQL. I think I can do this via VBA but I'd prefer it to be in SQL when possible.

[orange]

Why exactly do you want records for each day in the range? You can certainly calculate the number of days given the start and end dates.
What is the default end date for a new appointment? That is, if John Doe is assigned to a new job on Nov 15, 2016 and is supervised by Ima Boss, what is the Effective End Date?