Total less MAX and 2nd Largest Values

[Guest]

I've been reading other posts and I'm still confused.

Here is my problem. I have records that have 6 different test scores. I want
to find the total of the lowest 4. I know access is not excel but this seems
like this should be easy to do. So I have [Student], [Tests 1-6] and I want
to calculate [Overall Score] = total of lowest 4 scores out of all 6.

Perhaps someone could help me????

 

[Guest]

Try something like

SELECT Sum(TableName.Score) AS SumOfScore
FROM TableName
WHERE TableName.Score In (Select Top 4 Score From TableName Order By Score
Asc)