Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-10-15
3
Medium Priority
?
411 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 1600 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

604 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