Code: Select all
=IIf(DCount("*","tblAttPeriod","UnitID=" & [Code] & " AND [Forms]![frmAttendance]![txtDateFrom] Between [FromDate] And [ThruDate]")>0,"Booked","")
Code: Select all
=IIf(DCount("*","tblHoliday","HolidayDate" AND [Forms]![frmAttendance]![txtDateFrom] Between [FromDate] And [ThruDate]")>0,"Bank Holiday","")
The combinated code should check:
Has UnitID booked a holiday between [FromDate] and [ThruDate], if true then show "Booked" on the report, also if there is a date in tblHoliday then show "Bank Holiday"
Is this doable?
Cheers