Results 1 to 2 of 2
  1. #1
    Rhues is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Jan 2010
    Posts
    2

    Help with Conditional statement in query

    I am havgin trouble with writing this statement effectively

    Timely 6 mo test: IIf(IsNull([FY 09 6 Mo due],”“,IIf(([FY 09 6 mo due]>=[6 Mo Received]),"Yes", IIf(([FY 09 6 mo due]<=[6 Mo Received]),"No")


    I have FY 09 6 mo due as a date field that is automatically calculated based on a programs date. The 6 Mo Received field is a date field that is input by a user once a report is received. I am asking in this Timely 6 mo test field for it to automatically populate (using my conditiaonl statement) if the report is on time or not. I want this field to be null if there is no date in the 6 Mo Received field, to be Yes if the date indicates it was received on time, and No if it indicates it was received late.

    I cant get all three conditions to work together. Any help?

  2. #2
    Rhues is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Jan 2010
    Posts
    2
    Found solution.

    Timely 6 mo test: IIf(([FY 09 6 mo due]>=[6 Mo Received]),"Yes", IIf(([FY 09 6 mo due]<=[6 Mo Received]),"No"))

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

Similar Threads

  1. Conditional Query Question
    By Silver Rain 007 in forum Queries
    Replies: 0
    Last Post: 11-16-2009, 11:30 AM
  2. I need help writing a query statement
    By dking in forum Queries
    Replies: 1
    Last Post: 02-25-2009, 09:43 AM
  3. If then statement in query
    By ronnie4 in forum Queries
    Replies: 1
    Last Post: 01-20-2009, 10:49 AM
  4. Conditional Update query ...
    By valkyry in forum Access
    Replies: 0
    Last Post: 04-25-2007, 02:04 PM
  5. Conditional Format Query
    By Schwagr in forum Queries
    Replies: 3
    Last Post: 03-20-2006, 02:39 PM

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