Filter Or Populate List Box According to Two Date Fields (1 Viewer)

[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 1 & 3..

Would really appreciate your advice.entry

 

[MarkK]

Hi, it's considered bad form, and a violation of our rules, to post the same question in multiple forums. Please select the appropriate forum, and post your question there, once. Thanks in advance,
Mark

 

[pbaldy]

I'd expect a row source of:

SELECT *
FROM TableName
WHERE EntryDate = Date() OR RequestedDate = Date()

or something along those lines.