My output is differernt thta in the tutorials

[Lou_Reed]

In the next tutorial shown at this link:

http://www.functionx.com/access/Lesson30.htm

My output after the sequence of steps now shown:

Practical             Learning: Summarizing





In the bottom section of the window, change the header of the second         column to Qty: Category
Click its Total combo box and select Count
Change the header of the third column to Total Spent: Purchase         Price
Click its Total combo box and select Sum
Change the header of the fourth column to Average: Purchase Price
Click its Total combo box and select Avg
 
Right-click the query and click SQL View
SELECT     [Company Assets].[Asset Type], 
    Count([Company Assets].[Asset Type]) AS Qty, 
    Sum([Company Assets].[Purchase Price]) AS [Total Spent], 
    Avg([Company Assets].[Purchase Price]) AS Average
FROM [Company Assets]
GROUP BY [Company Assets].[Asset Type];

1. In actually I got this for the SQL code :
   
   SELECT [Company Assets].Category,
   Count([Company Assets].Category) AS Qty,
   Sum([Company Assets].[Purchase Price]) AS [Total Spent],
   Avg([Company Assets].[Purchase Price]) AS [Avg]
   FROM [Company Assets]
   GROUP BY [Company Assets].Category;
   
   
   
   I followed the steps in the instructions (also shown above), but there must be something missing, my output is not the same.
   
   
   What am I doing wrong?
   
   
   Respectfully,
   
   
   
   Lou Reed

[ranman256]

which is wrong?
are you sure both data values are the same in your table and the example? (BEFORE the query)

[June7]

Looks like another error in this tutorial to me.

Where it shows [Asset Type] in the SQL statement would be [Category] as shown in the design grid.

[Lou_Reed]

Well when I clicked datasheet view I got the same datasheet view as shown in the tutorial. So I guess the code
is in some way correct.

The only difference in my code is that I have Category where they have [Asset Type], yes it is more than one word so they use brackets.

That is the only difference that I can see.

Where in the design view do we put in Asset Type?

R,

Lou Reed

[June7]

You don't. That is not a field in the table. The tutorial errors in what it shows as SQL statement. The design grid is correct.