I have a report that at first when ran would give me the error message, "Multi-level GROUP BY clasue is not allowed in a subquery." I found a workaround that allowed me to run the report. My problem now is when I add a text box (=sum(budget)) to the report footer, Access automatically encounters a problem and crashes. The report runs without the =sum() text box. Can anyone offer why this is happening and offer any solutions on how this can be solved??