"Multi-level group by clause is not allowed in a subquery" error message

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..
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:

Then you might have to get your sum from the individual Source Tables (or Queries)

Something like this:

=DSum("[REG hrs]","[YourREGhrsTableOrQuery]")

Obviously, without seeing:
- Your data
- The way it is structured it.
- The Report's Design.
... it is impossible to know for sure.

So give this a try, and let me know the outcome.

cpasulaAuthor Commented:

It works perfect!   Thank you
Jeffrey CoachmanMIS LiasonCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.