MS ACCESS : PRACTICALS

MR.Phojithan,R.

By Creating Calculated Field

By using Select Query

By using Update Query

By Creating Calculated Field

By using Select Query

By using Update Query

Access SQL

    SELECT 

a.[stu id],
a.[stu name],
a.[sub1],
a.[sub2],
a.[sub3],
a.[Total],
a.[Average],

COUNT(*) AS Rank

FROM report AS a INNER JOIN report AS b

ON a.[Average] <= b.[Average]

GROUP BY

a.[stu id],
a.[stu name],
a.[sub1],
a.[sub2],
a.[sub3],
a.[Total],
a.[Average];