Hi Richard me again

I have only worked on the highest score so far.
Topscore: IIf([F1]>[F2] And [F1]>[F3],[F1],IIf([F2]>[F1] And [F2]>[F3],[F2],IIf([F3]>[F1] And [F3]>[F1],[F3])))
I got the right answer (not tested properly)
I'll think about the next highest score tomorrow.
My 10 week old son just rolled over from his back to his tummy. Ain't life grand.
Best wishes Alan Hill

---

Reply from Richard Rost:

Life is grand. Ha ha.

OK, I owe everyone an apology... the code that I posted earlier was written in EXCEL format. That's what happens when you spend 4 months of your life writing an Excel book... you start to see everything as an Excel problem. The AND() function is something you use in Excel, not an Access query.

Alan, you were right. The correct syntax for determining the top score in an Access query is:

TopScore: IIf([F1]>[F2] And [F1]>[F3],[F1],IIf([F2]>[F1] And [F2]>[F3],[F2],[F3]))