List dates between 2 dates?

[alicias4]

I asked a similar question in the queries section but haven't had much luck, so I'll try to simplify.



I'm learning Access as I go. Is there a way in this program to create a list of dates between 2 dates?

i.e I have Arrival Date and Departure Date. Is there a function or expression that will list all the dates on and between?

If I can get that, then I can do a count function to answer the question I need answered... otherwise I'm going to have to think of a different route. Any help would be appreciated.

[pbaldy]

If you're looking for a count, does the DateDiff() do what you want?

[alicias4]

Thank you for the reply!

The DateDiff only gives me a value of days.
If you go to the Queries Forum on here, There's a more detailed description of what I'm looking for. https://www.accessforums.net/queries...ers-31115.html