[AccessD] Obtaining 2 lowest values in a row

Group,

I have a table of records where I need to grab the 2 lowest values in a row.

For example:

1  100  50  25  98  75  66
2   98  100 45  63  51  21

so the result for row 1 would be 25 and 50 and the result for row 2 would be 21 and 45

I want to create a query that produces this result

1   75 (sum of 25 and 50)
2   66 (sum of 21 and 45)

Can anyone help?

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com