How to sum columns

[JavaToPerlNowVB]

I have a query and I want to sum up all the columns, This is the sql query that I have

SELECT CountSwitchGearInspectionByYear.[Inspection Year], CountSwitchDeficienciesByYear.Maint, CountSwitchGearInspectionByYear.[Units Inspected]
FROM CountSwitchGearInspectionByYear INNER JOIN CountSwitchDeficienciesByYear ON CountSwitchGearInspectionByYear.[Inspection Year] = CountSwitchDeficienciesByYear.[Inspection Date];

Should i use the create or replace view but since I just want the total at the end of the each column I think I have to use someother way.
Thanks for all the help

 

[coachdan]

To sum columns, you need to do so in a report - not a query.

coachdan32

http://www.malehsbaseball.com

 

[JavaToPerlNowVB]

could you explain what you meant by "do so", thanks

 

[MichaelRed]

do a search on these (Tek-Tips) fora with the term basRowSet or basRowSum.



MichaelRed