IIF Function

[Billy]

I have a table that contains 4 dates, what I want is to
create an expression that will tell me the earliest date,
ie. 1/1/04.

How can I use the IIF function?

 

[Wayne Morgan]

Try the DMin function to get the lowest (earliest) date.