See monthly Totals on Form

[mdg]

I have a form that tracks daily data and auto sums this data for the day in another area on the form. I would like to display the montly totals as well for the month that is presently displayed on the form. Is there way to do this without using a querry. I would like to simply calculate this right on the form if possible.
Thanks

 

[Mr. B]

You might try using the DSum() function

 

[vbaInet]

A SELECT statement is not a query right? You can use that as the Row Source of a Combo Box and filter it and Requery it in the Current event of the form.

But Mr. B's solution is easier though