Results 1 to 4 of 4
  1. #1
    hemanaguib is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    8

    Lightbulb If link child expiry field less than Today then don't show in expiry report

    Hi,



    I have main form with linked datasheet subform, where item in main form have subform include: (cost, Start Date and expiry date).

    I make an expiry Date report using the following criteria in Expiry date field query " >=Date()-7 And <=Date()+4 ". Report is working, but the problem that I want If I add for the same Item 2 lines in subform and one of them its expiry date more than Today, the item will not show in Expiry date report despite first line which already expired.

    Example:
    ===
    Today: 20/6/2017
    Subform Line 1 End Date: 18/6/2017
    Subform Line 2 End Date: 27/6/2017

    What I need to do, if subform had line 1 only, Item will show in report, and if subform had line 1 and line 2 Item will not show in report.

    I hope that I clarify my point and find an idea.

    Thanks;

  2. #2
    Bulzie is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Seems like in your example, line 2 does not fall within that date range parameter so would not show?

  3. #3
    hemanaguib is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    8
    Quote Originally Posted by Bulzie View Post
    Seems like in your example, line 2 does not fall within that date range parameter so would not show?
    That is true, what I want if 1 line out of range both lined will not appear.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    It seems that you need a totals query - group on item and get Max of date.

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

Similar Threads

  1. query expiry to show just out of date
    By richard_rendle1972 in forum Queries
    Replies: 1
    Last Post: 03-16-2015, 02:55 PM
  2. Parameter coming up for expiry date
    By FranCorona in forum Queries
    Replies: 2
    Last Post: 08-09-2013, 09:59 AM
  3. expiry date query help
    By graemespence1 in forum Queries
    Replies: 3
    Last Post: 11-22-2011, 09:23 PM
  4. Multiple Qualificaions with expiry
    By cottoman in forum Access
    Replies: 4
    Last Post: 10-25-2011, 06:15 AM
  5. Calculating Expiry Date -
    By Jojojo in forum Programming
    Replies: 12
    Last Post: 10-05-2011, 12:05 PM

Tags for this Thread

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