In Select Statement Sum Top 3

[emajka21]

ASP 2.0/C# Access 2000 database
I need to sum the top 3 race times. Below I can get the top 3 times but now how do I sum them?

SELECT TOP 3 qryRaceTime.RaceTime FROM (Registered INNER JOIN qryRaceTime ON Registered.BibNum = qryRaceTime.BibNum AND Registered.RaceYear = qryRaceTime.RaceYear) WHERE (qryRaceTime.RaceYear = ?) AND (Registered.RunnerID = ?) ORDER BY qryRaceTime.RaceTime

In the Where statement the ? refer to drop down boxes on my form. I bascially need to add the top 3 racetimes for each runner. Where do I put the SUM in this select statement?

I have tried numerous versions and I keep coming back with errors. I know I am missing something easy but for the life of me I can't figure it out.

PLEASE HELP!

Thanks!

[r035198x]

ASP 2.0/C# Access 2000 database
I need to sum the top 3 race times. Below I can get the top 3 times but now how do I sum them?

SELECT TOP 3 qryRaceTime.RaceTime FROM (Registered INNER JOIN qryRaceTime ON Registered.BibNum = qryRaceTime.BibNum AND Registered.RaceYear = qryRaceTime.RaceYear) WHERE (qryRaceTime.RaceYear = ?) AND (Registered.RunnerID = ?) ORDER BY qryRaceTime.RaceTime

In the Where statement the ? refer to drop down boxes on my form. I bascially need to add the top 3 racetimes for each runner. Where do I put the SUM in this select statement?

I have tried numerous versions and I keep coming back with errors. I know I am missing something easy but for the life of me I can't figure it out.

PLEASE HELP!

Thanks!

Moved from articles to forum section.

[Vidhura]

ASP 2.0/C# Access 2000 database
I need to sum the top 3 race times. Below I can get the top 3 times but now how do I sum them?

SELECT TOP 3 qryRaceTime.RaceTime FROM (Registered INNER JOIN qryRaceTime ON Registered.BibNum = qryRaceTime.BibNum AND Registered.RaceYear = qryRaceTime.RaceYear) WHERE (qryRaceTime.RaceYear = ?) AND (Registered.RunnerID = ?) ORDER BY qryRaceTime.RaceTime

In the Where statement the ? refer to drop down boxes on my form. I bascially need to add the top 3 racetimes for each runner. Where do I put the SUM in this select statement?

I have tried numerous versions and I keep coming back with errors. I know I am missing something easy but for the life of me I can't figure it out.

PLEASE HELP!

Thanks!

Try this

Select sum(A.RaceTime) from (SELECT TOP 3 qryRaceTime.RaceTime FROM (Registered INNER JOIN qryRaceTime ON Registered.BibNum = qryRaceTime.BibNum AND Registered.RaceYear = qryRaceTime.RaceYear) WHERE (qryRaceTime.RaceYear = ?) AND (Registered.RunnerID = ?) ORDER BY qryRaceTime.RaceTime) as A

[emajka21]

This worked, you are FANTASTIC. I have been staring at this for hours and you make it look so simple.

Thanks alot!!!!