Hi, I am trying to use Access to perform calculation based on data input by user. For example:

Based on data below, when I run query with received date = 13 Mar 2016, I am hoping Access to filter out record with received date = 13 Mar 2016 (which is Alice and William only) and auto fill up field "TotalDocReceived". thanks in advance for any help.

Ref_No Document1 Doc1ReceivedDate Document2 Doc2ReceivedDate TotalDocReceived
Alice Title 15 Mar 2016 Option 13 Mar 2016
Stephen Option 15 Mar 2016
William Payslip 13 Mar 2016
May Certificate 15 Mar 2016