Select query Total Grouping

[Guest]

Please what am I doing wrong? Access gives me the error message, "Cannot
group on fields selected with'*'". I am attemping to do some exercises in
"Access Inside Out" using the sample database Northwind. The query is select
with the Total row viewing.

 

[Douglas J Steele]

What is the actual SQL you're trying to run?

(If you don't know what I'm talking about, while you've got the query open
in Design mode, select View | SQL View from the menu. Select all of the text
that appears in the Query definition, and paste it into your reply)

 

[Roger Carlson]

Two ways to fix this:
1) Go into the Properties of the query and set the Output All Fields
property to NO.
2) Enter the SQL View of the query and remove the * from the field list.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

SELECT Orders.EmployeeID,
Sum(([UnitPrice]*[Quantity])-([UnitPrice]*[Quantity]*[Discount])) AS
TotalSales, *
FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order
Details].OrderID
GROUP BY Orders.EmployeeID;

 

[Guest]

Thank you Roger:
I tried the Properties/Output All Fields suggesting and it worked fine.
However, removing a "*" from the SQL view would not.

Thank you again,