Sum Trouble

[helpmeplease]

I want to sum only data in my report that falls between the form
dates...everytime I try to "Sum" , it says it's too complex. Do you see a
better way?

The goal of the report is to show ALL mandatory trainings (no matter the
date) and all other trainings that took place with in the form start and end
dates. I need it to show the total hours earned within the form dates as
well.

My IIf statement shows correctly under the detail section but I cannot get
the total in the employee footer.

IIf(Eval([Completed] Between [Forms]![frmDateSelect]![Start] And
[Forms]![frmDateSelect]![End]),[hours],0)

 

[John Spencer]

I would try a control with the following expression as its source.

=SUM(IIF([Completed] Between [Forms]![frmDateSelect]![Start] And
[Forms]![frmDateSelect]![End]),[hours],0))

I don't understand why you are using the EVAL function at all.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County