Filter Or Populate List Box According to Two Date Fields

[StanJx]

Hi, This maybe something simple but I couldn't figure it out yet . I have a list box with two date columns (EntryDate & RequestedDate). I need the list box to show records according to both dates.

For Example

Entry 1
EntryDate 9/12/2016
RequestedDate 9/13/2016

Entry 2
EntryDate 9/13/2016
RequestedDate 9/13/2016

Entry 3
EntryDate 9/12/2016
RequestedDate 9/12/2016


List box on the 13th should show entries 1 & 2. The list box on the 12th should show entries 1 & 3..

Would really appreciate your advice.

 

[PWise]

i dont know what fields you want to display
burt your rowsource should be something like

Select field1,field2,...
from tablename
where EntryDate = date()
union
Select field1,field2,...
from tablename
where RequestedDate = date()