Query to list out cases with existing outstanding item and newly received item

[winxmun]

Hi, Refer to excel file attached (with sample data and query needed). Please assist on how to run the query. thank you very much.

[jonh]

Could you explain the data? I looked at it, but I couldn't understand it.

[winxmun]

B2:O9 is the sample data.
C13:D17 is the report on no. of records received for the day. "Received" meaning "Date Received 1" or "Date Received 2" or "Date Received 3" is not null (based on date received).
F13:G17 is the report on No. of records outstanding for the day (accumulative from previous days). "Outstanding" meaning "Date Received 1" is not null and "Date Completion 1" is null OR "Date Received 2" is not null and "Date Completion 2" is null OR "Date Received 3" is not null and "Date Completion 3" is null.

Based on the sample data, on 28/7/2016, how to create the query to list out the 4 cases (Ref No. 177360, 177267, 81557 & 78491) that has existing outstanding item?