I have a record source created by a query that I want to use on a report. Another item on the report needs to be Due Date (Unbound Text Box) and needs to be calculated using the following rules.
Service ID Due Date
IME Due date will be 7 calendar days from the Date of IME (it will be blank if [/qu no IME date has been entered yet)
RR Due date will be 10 calendar days from the Date the RR_Doctor letter is created.
ERR Due Date will be 7 calendar days from the date the RR_Doctor letter is created.