I have been using Access starting with version 1 so that's quite awhile. I have a system where the  daily timesheet needs to be linked to an accomodation record but the accomodation record can span several days so I need to list the actual dates between the start of stay and end of stay to link the appropriate timesheet. So if the timesheet date is 29/11/2012 and the accomodation record is for the start date 28/11/2012 and end date of 3/12/2012 I need to list all the dates between those dates. I've tried very conteration of datediff, datepart, dateadd with my joy. Can anybody help?

---

Reply from Richard Rost:

Without a sample of your data it's difficult for me to get a grasp of how your tables are set up and exactly what you need to do. This is the hardest part about helping someone with their database... I don't know what your terms mean. Can you show me a sample and explain in detail what you're trying to do? Better yet, if you can RELATE your concepts to something that ANYONE would understand, that would help. For example, I have no idea what your "accommodation record" means, but I would understand, for example, customers and orders, or vehicles and drivers, etc.