Thanks for the reply namliam !
I thought the 4 ) at the end would close everything (BO Trate)
I have added the ) to close each DateAdd Function but it seems that the query is bringing back an error.
NextDue2:
IIF( [Completed] =True And [Frequency] ="Daily"
,DateAdd("d",1, [Next Due...