Grouped Reports or Queries (1 Viewer)

Good day everyone!

I am working on a List or database that looks like the one below...

ID Date Debit Credit
01 1-May-2010 0 10,000
02 1-May-2010 10,000 0
03 1-May-2010 66.75 0
04 4-May-2010 2,500 0
05 4-May-2010 1,010 0
06 4-May-2010 0 2,500
07 4-May-2010 75 0
08 4-May-2010 0 1,000
09 7-May-2010 510 0
10 7-May-2010 500 0
11 7-May-2010 0 500
12 7-May-2010 0 70

I would like to use Ms-Access queries or reports

Or Other solutions
will match Debits vs Credits for each day
then display the matched exact values (between Debit and Credit values)
Or display the values (also between Debit and Credit values) with the difference of up to $15
Table results is listed below...

ID Date Debit Credit
01 1-May-2010 0 10,000
02 1-May-2010 10,000 0
04 4-May-2010 2,500 0
05 4-May-2010 1,010 0
06 4-May-2010 0 2,500
08 4-May-2010 0 1,000
09 7-May-2010 510 0
10 7-May-2010 500 0
11 7-May-2010 0 500

Thanks!

What query are you using to carry the values forward or is that what you are asking for?

Yes, In other words, The bottom list in my example above is what I am expecting to get using a select or maybe a summary query...

This should get you started...


...note you will need both ID and Date to get the correct order.