MS Access question: Finding the minimum value in multiple fields

Factual Questions
2

You were close.

The Min function needs a range. So if your values are in cells A1 through A3, the correct syntax is Min(A1:A3)