How to appear every single date with event when using between function in query

[mes3]

I've been using between function with two dates in query and also have put event. There is no mater to display it's event at the start and end date, but if the different date more than one day, for example:



Query 1:

Start Date	End Date	Event	Amount Days
24/04/2012	27/04/2012	Leadership Course	4

the report only display the first and last date with it's event but not display date to 2, 3 and 4. While actually what I want to do in the query when I key in even at the start and end date, the result in a report should display every single date with it's event automatically just like this

Report 1:

Date	Even
24/04/2012	Leadership Course
25/04/2012	Leadership Course
26/04/2012	Leadership Course
27/04/2012	Leadership Course

If different function not suitable to get that result, may be there are another way to solve it. Please help me.

1968

[June7]

You want to show records that don't exist. This will not be easy to do. I doubt can be done with just query but will call for VBA code and temp table.

You also don't show any code between the code tags.

You might find this of interest https://www.accessforums.net/databas...ses-18459.html