Sum OF Two Fileds

[Eranka]

Hi

Please see the screen shot below




Above is query that im running. is there is a way to get sum when two fields are equal. Ex: there are two F1's then i need the sum of total rate (42000) and leave the U1 as it is (16,800). Appreciate your help

[ranman256]

select [Name], [LevelOfUnit] , sum([rate]) from table

[ArviLaanemets]

SEELCT Unit_Name, SUM(TotalRate) AS Total_Rate FROM YourTable GROUP BY Unit_Name

or

SEELCT Level_Of_Unit, SUM(TotalRate) AS Total_Rate FROM YourTable GROUP BY Level_Of_unit

or

SEELCT Unit_Name, Level_Of_unit, SUM(TotalRate) AS Total_Rate FROM YourTable GROUP BY Unit_Name, Level_Of_unit

[Eranka]

HI

i tried above statement with Access Query but it give me below error



Query Used: SELECT [LevelOfUnit],Sum([Rate]) FROM [Course]
Is it possible to use a query name after From in sql.

Something like
SELECT [LevelOfUnit],Sum([Rate]) FROM [Query1]

[ArviLaanemets]

You can't have aggregate query without GROUP BY or HAVING clause.

[Eranka]

Hi


above is a report i created, i want the sum of (08:00+12:00) to shown is the Foundation filed, and the 3rd record to be shown in Diploma field. any suggestion how to do this part?