Access SQL Developer

Need assistance with a query to return data for every date within a date range. Currently have DB with query returning data relating to scheduled work to an excel spreadsheet and need to alter so that if the work start / end dates are on different days there will be a row in the spreadsheet for each date within the date range. Possibly solution is a new table in the DB with all possible dates and INNER JOIN.