Update Min Help

[Mac1206]

I would like to create a Update with the Min for the two fields in my table, what is the most efficient way to achieve this?

Import	Domestic
645	656
601	636
636	655
601	636
688	700
598	637

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

The MIN/MAX functions in Access work against a single field/multiple records (not multiple fields within a single record).
So the way I would do it is with the following calculation:

IIF([Import] < [Domestic],[Import],[Domestic])

 

[Mac1206]

The MIN/MAX functions in Access work against a single field/multiple records (not multiple fields within a single record).
So the way I would do it is with the following calculation:

IIF([Import] < [Domestic],[Import],[Domestic])

Thanks a million and many more...