Totalling up from two fields with various quantities selected

[Cran29]

I have two tables one called PPEEmployee which has the following fields equipment issued date issued and the quantity 1-2-3 etc. I also have a table called PersonalProtectiveEquipment with the fields Type/ ItemCost/ PackCost and a total cost


How would the query be in order to add the fields ItemCost and PackCost to display in TotalCost. The quantity isued would need to mutiply these figures by what ever is selected eg in the quantity field by 1-2-3 . I have a calender table and would like a total start date and end date for the year Dont know if this is the correct line any help would be great

[June7]

How are these tables related? Is there a pk/fk to link them?

TotalCost should not be a field in table. This should be a calculated field in a query.

[Cran29]

The primary key is linked to the employee table from the PPE table. Perhaps i am going the wrong way about this. I have attached pictures of the set up. Basically it records what equipment is issued to an individual on a specific date along with the quantity. It all works fine. I would now like to add a cost to the items issued and run a total cost for each item in the list.

[June7]

What is relationship of Employee and PersonalProtectiveEmployee tables? The tables are linked on the primary key fields. This can be done only if one of the pk's (the 'child' table) is not autonumber and the tables have one-to-one relationship.

[Cran29]

I have used the following Query and it returns results. However it returns all the information in strange groups. It adds most of the quantities together but separates some. Why wont it group them totally into Rigger gloves one line total etc. When i try and enter the following query to display only between dates it returns nothing any ideas

Between #01/04/2012# And #31/03/2014#

[June7]

It's because you have included Quantity and ItemCost as grouping criteria. Remove them. Then under the Cost calculation, select Sum instead of Expression.

[Cran29]

Managed to crack it with the help of a friend