Beginner needs help. Trying to create simple Totals query

[beezelbuz]

Hello everyone and thanks for the assistance.



I have an Items table with primary key as "Item ID"
I have an Order Line Items table with primary key as "Order ID"

Order Line Items table has the order ID and the number of items ordered for each ID
I am trying to create a query that Prints the item name in column 1 and in column 2 post the total each was ordered.

Pics of tables are included.

[June7]

Need to link the Item ID fields in query.

Then maybe you want Sum(Quantity) instead of Count([Item ID]).

Strongly advise not to use space in naming convention.

[Gicu]

I think you need to add as the first field in the totals query the [Order ID] (Group By), then the [Item ID] or [Item Name] from Items (you need to join them on Item ID as June7 said) and finally TotalPurchased: Sum(Quantity).

Cheers,

[beezelbuz]

OMG! Thank you so much!!! Needed to JOIN the ItemID fields in the two tables. Fantastic it now works!