I have a report (access 2000) which is based on a 'final' query. This 'final' query is based on several queries. One row in my report shows as follows (each column comes from individual queries):
Employee ID REG hrs Overtime hrs Vacation hrs
I want to have the totals for each column at the end of my report. I added a text box in the 'report footer' with the Sum (i.e. Sum([REG])), but when I run my report I get this message: "Multi-level group by clause is not allowed in a subquery" .
Please let me know what I am doing wrong..