Solved

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

Posted on 2008-10-15
3
365 Views
Last Modified: 2013-11-28
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..
0
Comment
Question by:cpasula
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 400 total points
ID: 22727308
cpasula,

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.

JeffCoachman
0
 

Author Closing Comment

by:cpasula
ID: 31506367
JeffCoachman,

It works perfect!   Thank you
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22733016
;-)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question