I have a (1 to many) table which can contain an arbitrary number of fields, all linked to one field in another table.

i.e - table [Answers] may have 5 answers for a single question in table [Questions] - you with me?

What would be appropropriate SQL to find the LARGEST number of answers to a question?

I'm thinking something like "SELECT MAX(COUNT(answerText)) WHERE questionNumber = 1"
?