I have a database that consists entries that are either cash or check. I
want to be able to use the DSUM function to sort by date (the first column
below). I have been able to do a workaround via SUMIF, but I feel that DSUM
ought to work.

=SUMIF(Date,A1,Cash)
where each record has a different value in the CRITERIA field and I am able
to use labels for the RANGE and SUMRANGE arguments supplied to SUMIF.

What I actually need is a way to sort for two columns (Date and Contact),
but for starters sorting by date would be fantastic. Thanks in advance for
your help!


Date Contact Signature Cash Check
10/1/2005 Kevin Gabe Kent 5
10/1/2005 Kevin Vernon Lukehart 10
10/2/2005 Kevin Don Curry 11
10/2/2005 George Wendy Bryant 36
10/3/2005 George Dorothy Miller 20
10/4/2005 Bart Jeanette Fox 5
10/4/2005 Bart Stacy Taiber 10
10/4/2005 Bart Jill Norton 11
10/5/2005 Bart Judith Jessup 36
10/5/2005 Rubben Ron Paine 15
10/5/2005 Rubben Kathy Weinberg 5
10/5/2005 Rubben Amy Lau 10
10/6/2005 Craig Marissa Smith 36
10/6/2005 Craig Marlin Weber 20
10/6/2005 Craig John Smith 15