**ASAP** Sum of Query Expression Grouped by Employee Number

[TommyC]

Here is my assignment details.

List the employee number, name, total amount of commissions on orders taken in January 2007. The amount of commission is the sum of the dollar amount of products ordered times the commission rate of the employee.

I can't get the commission to total by EmpNo, FirstName, or LastName without an aggregate function error. What am I doing wrong?

This is my current progress:




and the result... The result on the left is what I'm getting, the result on the right is what I should be getting.

[ajetrumpet]

Note: providing assignment help is not a requirement to be a contributor here.

It's disheartening to read "ASAP" in the title of a thread. You'll get more appreciation by not doing it.

You need to GROUP BY every field that is not your calculation. you're getting the error mostly because of that reason. Do you understand GROUP BY clauses? How about aggregations?

with the number of fields you have there in design view, grouping your query with just one calcuated field in it will yield you incorrect results again. Be aware that using a GROUP BY clause will yield the calculation you've specified for every DISTINCT ROW, not Employee numbers.

for example, if you group by every field in your query like Access requires, the way you have things now, you'll get this:

employee 1 | order 1 | commission: $1.34
employee 1 | order 2 | commission: $4.39

etc, etc...

Only include fields that are not calculations in which the combination of them will always be the same for each employee ID. make sense?