I have a query that has a DateofService field that has the criteria Between #7/1/01# And #6/30/02#.
On the report I need one text control to draw from the same query and the DateofService field but further restrict the date of service to one month. Working with tech support he directed me to DSum we tried this control source

=DSum("[SumofLengthofService]","qryIndividualProductivity","[DateofService] Between #10/1/2001# And #10/31/2001#")

We go #Error when the report was ran. Does anyone have any suggestions?

Thanks! Fay