Select First Date to Occur from Mulitple Fields

[CPinna777]

Hello

I have an Form referencing a Table built in Access 2007 where there are multiple date fields ie

Expiration 1 - 8/1/2013
Expiration 2 - 9/1/2013
Expiration 3 - 12/1/2013



etc

What I would like for there to be is a field present on the form that is able to select which of the dates will occur first (such as a min value of some sort). How can this be achieved?

[pbaldy]

How about

Minimum or Maximum Value Across Fields of Record