I have a problem that I'm not sure can be solved. I have a report (see Report1 attached) which will show both those OnLeave (OnLeaveStartDate, OnLeaveEndDate) and ALSO those Seasonal (SeasonalStartDate, SeasonEndDate).
The problem is in how to get both types of leave to show on the report with their respective dates. There is one table holding both check boxed fields "On Leave" and "Seasonal" and the database populates the table with the respective starting and end dates OnLeaveStartDate, OnLeaveEndDate, and SeasonalStartDate, SeasonEndDate.
If I superimpose the "SeasonalStartDate" and "SeasonalEndDate" fields over the top of "OnLeaveStartDate" and "OnLeaveEndDate", the attached report design shows the idea (see ReportResult attachment).
Namely the attached "ReportResult" shows only the seasonal volunteers and their respective dates. The OnLeave volunteers dates are hidden.
Of course if I were to NOT superimpose the fields for seasonal over "on leave", (see ReportExp), this leaves a formatting issue - see attached ReportNSuper.
Any hints as to how to solve either the superimposed textboxed field and or how to reformat the report to have everything nicely fit proportionally?