Ronald de Graaf
New member
- Local time
- Today, 22:13
- Joined
- Sep 12, 2020
- Messages
- 16
Hey,
I have a problem that I cannot resolve. Been on it for a few days now.
What I want is a report with all the days of the month. For example in April, day 1 to day 30. All these days must be included on the report.
I also have a table (tblEvents) with events in it. An event has a date.
In addition, an event record can have 3 option dates: Option1, Option2, Option3
What I want is that all events where the date (eventdate or option1 or option2 or option3) is equal to the day number in April (on the report) are shown. I tried to create a subreport and link it with the day number to the main report. But that does not work.
As an example: suppose an event has as event date April 3 and option date (option1) for example April 1.
This event must then be shown in the report on April 1 as well as April 3
Hope it's a little clear.
Anyone have any idea? Can someone help me on my way? Thanks in advance!!!
Greetings, Ronald
I have a problem that I cannot resolve. Been on it for a few days now.
What I want is a report with all the days of the month. For example in April, day 1 to day 30. All these days must be included on the report.
I also have a table (tblEvents) with events in it. An event has a date.
In addition, an event record can have 3 option dates: Option1, Option2, Option3
What I want is that all events where the date (eventdate or option1 or option2 or option3) is equal to the day number in April (on the report) are shown. I tried to create a subreport and link it with the day number to the main report. But that does not work.
As an example: suppose an event has as event date April 3 and option date (option1) for example April 1.
This event must then be shown in the report on April 1 as well as April 3
Hope it's a little clear.
Anyone have any idea? Can someone help me on my way? Thanks in advance!!!
Greetings, Ronald