possibly a DSUM question?

Hello,

I searched the forum, and have found similar posts, but not exactly what i am looking for, and cant put the rest together on my own.

Here is a picture of excel sheet.grubform.jpg


In the "A" column, there are dates... these will change daily. Sometimes there may be only one row per date but other days there can be as many as 50 or more.

I am wanting to use a DSUM (or other sum command) to find all matching dates and then add the number values in column "K" (which is titled Deposit) and display total in a cell on a different tab.

In non programmer/coder ill try and explain a second way.

1) Scan column A rows 1 through 1000
2) If there are matching entries (dates) in column A
3) Then check corresponding row/rows for number values in column K
4) If there are numbers in the corresponding row column K
5) Then add those numbers, print them and the matching date (from step 2 above) on excel tab titled "Deposit", in the first empty row, column A and B.
6) Repeat steps 1 through 5 until all dates are accounted for.

I hope this makes sense... thanks guys...

man i wish i started studying this stuff earlier!!!

I think i am going to try a VBA or Macro route and export to access database, then just run queries for the info i want.