DSUM HELP!!!

[jessedh]

Hi all,

Now have I got a conumdrum for you.

Here it goes. I have a crosstab that needs to display a running total for a year broken out by product.
ie:

dog cat
1-2001 1 0
2-2001 3 1

would be displayed if this was the actual data

dog cat
1-2001 1 0
2-2001 2 1

I know I should be using DSUM, but I just can't get the syntax. Any help is appreciated.

Just to make it easier, the table name that CT is based off of is "Overrides", "ClosedDate" is the mm-yyyy formated field and "loanamount" is what has to be summed.

Thanks in advance
Jesse

 

[tsumrall]

dsum is an domain aggregate function. Likely you need just Sum.