Access Query Totals Question

[Hadi Lalani]

i have a Table in Access witht he following columns.
Co ID
Cust ID
Part Code
Q1 Amt

I need to create a new calcualted column which would add amounts from Q1 Amt column for certain parts codes, below are couple of records from the database

Record 1
Co ID = 815
Cust ID = 000194
Part Code = 1/2 screws
Q1 Amt = $ 410.00

Record 2
Co ID = 815
Cust ID = 000194
Part Code = 3/4 screws
Q1 Amt = $ 210.00

I need to have the final query look like below

Co ID Cust Id Part COde 1/2 screw Q1 Amt Part Code 3/4 screw Q1 Amt

or like below

Co ID Cust ID Q1 Amt Total

any help would be greatly appreciated.

Thanks

Hadi Lalani