[ cf-dev ] Compilcated SQL query on access

[Giles Roadnight]

I have a meetings table, a drivers table and a drivers points table. Each driver has points for each meeting. For a series the total points are the best 5 out of 6 scores that a driver has got.   Is it possible to write a query to do this in access?   Something like:   Select sum(select top 5 points from driverpoints where driverid = d.id) as total, driver.drivername From driver d Order by total   I’d test this but I don’t actually have the tables or data yet. I am certain the above won’t work though as you can’t selects with a select statement in access (can you?).   Is there another way of doing this?   Thanks   Giles Roadnight http://giles.roadnight.name