Daily Sum (2002 SP3)

[pooja]

What would be the easiest way to calculate a daily sum? I have three fields called Cash, Checks, CreditCard and I'd just like to have each one sum at the end of the day. Since it's all going into the same table, I do need the sums to be separated by date.

Thanks.
Pooja

[HansV]

You can do this in a report. If you use the report wizard to create it, you can specify that you want to group by date, and that you want to sum per group.