Control source in textbox problem 1

[jpl458]

I have a text box on a form and want to display the sum the of dollar amounts for the last seven days. My last attempt looks like this:

=DSum(("[ArAmt]","[dbo_Transaction_Table]"),"
[dbo_Transaction_Table]![Date_of_Transaction] ">DateAdd("d",-7,Now()))

The first part works =DSum(("[ArAmt]","[dbo_Transaction_Table]")

But when I add the where part (The DateAdd) it don't work.

Very frustrating

Thanks in advance

jpl

 

[PHV]

=DSum("ArAmt","dbo_Transaction_Table","Date_of_Transaction>Date()-7")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

It worked just fine, and I can see what I was doing wrong.

Thanks for the quick response.

jpl