Results 1 to 4 of 4
  1. #1
    AJ_25 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Apr 2018
    Posts
    12

    What is this logic doing?


    Hi,

    Can anyone please tell me what this logic is doing?

    Renewed: iif ([Ren Date] between [Ren_due]-7 And [Ren_Due]+15, 'Yes','No')

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    It is checking to see if the "Ren Date" falls within the following window:
    7 days before the "Ren Due" date and 15 days after the "Ren Due" date.
    If it falls within that window of time, it is returning "Yes", otherwise, it is returning "No".

  3. #3
    AJ_25 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Apr 2018
    Posts
    12
    Thank you for you're explanation

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome.

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

Similar Threads

  1. code logic help
    By jscriptor09 in forum Programming
    Replies: 1
    Last Post: 10-28-2012, 09:38 AM
  2. Please help with the logic
    By Del23 in forum Access
    Replies: 1
    Last Post: 08-23-2012, 12:13 PM
  3. need better VBA logic than I currently have
    By jscriptor09 in forum Programming
    Replies: 4
    Last Post: 11-27-2011, 09:16 AM
  4. Can't get the logic right.
    By Nouri31 in forum Queries
    Replies: 3
    Last Post: 03-31-2011, 08:25 AM
  5. Relationship Logic
    By Huddle in forum Access
    Replies: 2
    Last Post: 01-25-2011, 04:27 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