Combine multiple columns into one column

[serino64]

Hello Everyone,
How do I combine three columns into one column. I have one Table Called "SalesSource" with Four Fields.

Source
TotalAdvertise
Total ColdCalls
Total Website.

Source TotalAdvertise TotalColdCalls TotalWebsite
Advertising $4,000.00
ColdCalls 7,500.00
Website 10,0000

I would Like to join them to one column.

Source Total
Advertising $4,000.00
ColdCalls $7,500.00
Website $10,000.00

I Appreciate your assistance...

 

[Remou]

As in:

Total: Nz([TotalAdvertise])+ Nz([TotalColdCalls]) + Nz([ TotalWebsite])

?

 

[PHV]

SQL code:

SELECT Source, Sum(Nz(TotalAdvertise,0)+Nz(TotalColdCalls,0)+Nz(TotalWebsite,0)) AS Total
FROM SalesSource
GROUP BY Source

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[serino64]

Thank You So Much, Worked out great!