there is a field 'from date' and 'to date' i can calculate how many days is the difference but i also want to modify table or create new table with each date
for example: from date: 4-february to date: 7 february i want to split this data and to be shown as:
from date 4 feb to date 5 feb
from date 5 feb to date 6 feb
from date 6 feb to date 7 feb
how can make access to calculate the difference of dates and split the date day by day and create new lines in the database with splitted data.