Now having another issue with this. While trying to build the rota I want to lookup a table to see if the colleague has booked off holiday, I came up with this.
Nz(DLookUp("[Type]","tblAmendments","[Colleague_ID] =" & [ColleagueID]),Nz(DLookUp("[01day]","qryrotadefaults","[Shift] =" &...