Revenue and volume by type number

Is revenue something other than Quantity * Price?

If you want to run this across all orders, you would use the above calculation and group by Type Number, excluding all other columns.

Could you please get me started with groups.  I already have revenue as a field. I have generated a table of type numbers

That could be a query like:

Select
    [type number],
    Sum([quantity]),
    Sum([revenue])
From
    YourTable
Group By
    [type number]

Select allOpen in new window

CAN I DO THIS WITH CROSSTAB?

You can use GROUP BY and various aggregate functions to create a query. For example, to SUM by Quantity over a specific Group:

SELECT SUM(SomeField) FROM YourTable GROUP BY YourGroupField

In your case, if you want to sum the quantity:

SELECT [Type Number], SUM(Quantity) FROM YourOrdersTable GROUP BY [Type Number]

To get the Revenue:

SELECT [Type Number],  SUM(Quantity * UnitPrice) FROM YourOrdersTable GROUP BY [Type Number]

Of course you'd have to change Table and Column names to match your project.

Hi Gustav
Forgive my ignorance...Does this mean I must write the SQL code rather than use the Query designer?

That's up to you.
Open a new query, go to SQL view, paste the code, and edit it to match you table and field names.
Then you can switch to the design view to study.

This is my code:

SELECT SUM([Qty])  FROM Query1 GROUP BY [Type]

SELECT [Type], SUM([Qty]) FROM Query1 GROUP BY[Type]

SELECT [Type],  SUM([Value] FROM Query1 GROUP BY [Type]

I get  "Syntax error in query expression '[Type] SELECT [Type]" after saving

You can only have one Select in a normal query.
See my query above.

Thanks to everybody who helped.  It is working well now!

You're welcome.