Hello!
I need to create a query that would return the name of applicants that have not replied to a survey sent out with a particular due date. The following are some of the fields (in red) that I believe should be part of the iif statement.
StudentName
QuestionX (The answer or response to the survey question)
ResponseDueDate (Date the response is due)
ResponseDate (Date the surveyed actually responded)
The idea is that if I run a report to see who has not responded after the due date I should be able to see the name of the student. Therefor, if I run the report today and today's date is greater that the ResponseDueDate AND the ResponseDate is null, THEN I should return the name of the student.
Thank you so munch for your assistance!