I have a tblHolidays that lists only holidays of each year :
Is there any way to use this table to create a query that contains all dates (Not only holidays)
Something like :
I've used --- to shorten the list. The query should contain all the dates between.
Thanks.
HolidayPK | Holiday | Remarks |
---|---|---|
1653 | 2024/05/02 | Elders Day |
1654 | 2024/05/24 | Sport Day |
1655 | 2024/05/28 | Culture Day |
Is there any way to use this table to create a query that contains all dates (Not only holidays)
Something like :
dDate | Remarks |
---|---|
---- | |
2024/04/29 | Ocean Day |
2024/04/30 | |
2024/05/01 | |
2024/05/02 | Elders Day |
2024/05/03 | |
---- | |
2024/05/24 | Sport Day |
---- | |
2024/05/28 | Culture Day |
---- |
I've used --- to shorten the list. The query should contain all the dates between.
Thanks.
Last edited: