Sum of only todays date

[chewy]

I have a form that inputs check information. I have a textbox on the bottom of the form that calculates the sum of the checks entered. That works fine. But what I want to do is only calculate for todays date. Is there a way to do this by changing the control source? Or do I have to use a query to do this?

 

[Mile-O]

The Sum aggregate function doesn't seem to allow for criteria but you could use the DSum domain aggregate function.

 

[Vassago]

You are probably going to run into some problems just with the field being called "Date" since this is a built in field for Access. I would try using a different name if I were you.

 

[chewy]

Thanks guys works great