1. Create a new record query
  2. On the Criteria tab, select Activity, Summary, Record balance
  3. Select the appropriate Operator and enter a value (e.g., Operator = Greater than and Value = 0 to see all balances greater than 0)
  4. Select the Filter tab on the Edit Field Criteria screen
  5. Select End date equals and click Change
  6. Enter the specific date for the query in the Value field
  7. Click OK, and then click OK again
  8. Select the Output tab and select any appropriate Output fields
  9. Save and run query