Merge Tables

[Guest]

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


any help would be greatly appreciated.

Thanks

Hadi Lalani

 

[b-sql]

still looking for help? I am not certain about the
results you are after.

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

815 000194 1/2 screws 410.00
3/4 screws 210.00

? are you wanting an additional column to give you the
combined total of $620.00?

if that is the case then you simply add another column
customer total: Q1Amt+Q2Amt and format it for currency.

-----Original Message-----
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