conditional running sum formula error

[beaudreaux]

I have the followinf formula listed below and I am receiving the message: "The expression you entered contains invalid syntax. You may have entered an operand without an operator." I am not sure exactly where is the problem. Any help would be greatfull. This is in a report and I need this to be a conditional running sum that figures for each quarter and starts over at each quarter.

=DAvg("[Strght Avg Abdn%] ","[Service Guarentee Daily QRY]","Date Between #" & DateAdd("d",Datediff("d",if("d",if(month[date]<4,dateserial(year[date],1,1),if(month[date]<7,dateserial(year[date],4,1),if(month[date]<10,dateserial(year[date],7,1),dateserial(year[date],10,1))),[Date]) & "# AND #" & [Date] & "#")

Thank you

[pod]

I am not an expert but the double quotes around the two field names don't seem right, try removing those ...

=DAvg("[Strght Avg Abdn%] ","[Service Guarentee Daily QRY]",

This is a complex if not confusing formula. You should try putting constant values to help you troubleshoot.

[beaudreaux]

That did not work, that particular part is identifying the field and the query the field is in. Also tried using as the expression builder would place into the formula of: [Service Guarentee Daily QRY]![Strght Avg Abdn%]. Still no result