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;