Where Condition for multi criteria reprt

[donsi]

Hello,

Trying to figure this out for last few hours. I am new and self taught DB. Here is the problem. DB is for Issue/Return items. Sometimes items are checkout on day1 and cheked in on day2. When an item is issued, it generates and unique Tras No, which shows as pending in a separate form until returned. To make this happen i needed to created two fields, IssDate and RtnDate. Report is based on the query and want to filter it by the dates for which I have a form. When I use,

[IssDate] Between [Forms]![NavigationForm]![NavigationSubform]![TxtGDFrom] And [Forms]![NavigationForm]![NavigationSubform]![TxtGDTo]

It gives me only with issued item and ignore items returned (all items).

if i use

([IssGamingDate] Between [Forms]![NavigationForm]![NavigationSubform]![TxtGDFrom] And [Forms]![NavigationForm]![NavigationSubform]![TxtGDTo]) And [RtnGamingDate]Between [Forms]![NavigationForm]![NavigationSubform]![TxtGDFrom] And [Forms]![NavigationForm]![NavigationSubform]![TxtGDTo]

it gives me blank report.

The way I would like to display report is as below

 

[pbaldy]

Try Or rather than And between the two criteria.