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?

[TABLE="width: 296"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Import[/TD]
[TD]Domestic[/TD]
[/TR]
[TR]
[TD="align: right"]645[/TD]
[TD="align: right"]656[/TD]
[/TR]
[TR]
[TD="align: right"]601[/TD]
[TD="align: right"]636[/TD]
[/TR]
[TR]
[TD="align: right"]636[/TD]
[TD="align: right"]655[/TD]
[/TR]
[TR]
[TD="align: right"]601[/TD]
[TD="align: right"]636[/TD]
[/TR]
[TR]
[TD="align: right"]688[/TD]
[TD="align: right"]700[/TD]
[/TR]
[TR]
[TD="align: right"]598[/TD]
[TD="align: right"]637[/TD]
[/TR]
</tbody>[/TABLE]

 

[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...