Min value of two date fields in same table

[swtrader]

I need to find the earlier of two separate dates in the same table and
populate a field in the same table with the earlier date.

[Tom van Stiphout]

On 28 May 2005 08:41:35 -0700, "swtrader" <da******@yahoo .com> wrote:

Write an update query. Use the DateDiff function to determine if
field1 is greater than field2, or vice versa. Use the IIf function to
output either field1 or field2.

Still problems? Show us what you have so far.

-Tom.

I need to find the earlier of two separate dates in the same table and
populate a field in the same table with the earlier date.