How to sum a table column

[Martina_Hawkins]

Hi,

I have a table called Equipment List with fields
Item Id - Key
Category,
Description
Current Location
Costs - VC - Related Cost details

I have a table Costs with fields
Item Id - Key
Purchase Date,
Cost
PO No

so the costs show as an inline view in the Equipment View for each Item

What I want to calculate is the total cost of all items.
I want to sum the Cost Column in the Costs table.
In Excel this would be =SUM(Tbl_Costs[Cost])

I have added a VC in the Equipment List Table
Sum([Costs][Cost]).

I want to show a list of
Item Id
Cost
and show the total costs for all these items

It seems very simple, just get the sum of a column but I can’t figure it out.
Any help much appreciated