Question about Sum()

[Hank Stalica]

I have a form with two text boxes. Their control sources are as follows:

TextBox1: =Sum([Amount])

TextBox2: =Sum([Tables]![tblDeposits]![Amount1])

Text Box 1 will display fine if it's the only text box. When I add Text
Box 2, I get #Error in both text boxes. If I remove TextBox1, I still
get #Error in TextBox2.

What am I doing wrong?

Thanks,

--Hank

 

[Hank Stalica]

I actually figured it out. I used the DSum function.

--Hank