Results 1 to 4 of 4
  1. #1
    vinsavant is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    20

    IFF AND Statement

    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!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try this in the criteria of the response due date:

    < Date()

    And this in the criteria of the response date:

    Is Null
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    vinsavant is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    20
    Thank you so much! It worked!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 04-29-2015, 01:38 PM
  2. Help with IIF statement please
    By aellistechsupport in forum Queries
    Replies: 6
    Last Post: 06-20-2014, 12:56 PM
  3. if statement in sql statement, query builder
    By 54.69.6d.20 in forum Access
    Replies: 4
    Last Post: 09-11-2012, 07:38 AM
  4. Replies: 7
    Last Post: 08-17-2011, 01:49 PM
  5. SQL like statement?
    By Cojack in forum Queries
    Replies: 4
    Last Post: 09-21-2010, 04:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums