Need a query to compare multiple dates and display earliest date.

[K1NJO]

I have a table with multiple date columns. What I need the query to do is to compare these date columns and display the earliest date as well as which column it came from.

For example, the table has PicDate, DocDate, TestDate, ExpDate, ExpItem. After comparing PicDate, DocDate, and TestDate, the query would display the results. The ExpDate column would show the earliest date from the 3 columns, and the ExpItem column would show which item it came from.

[pbaldy]

That is likely a normalization mistake, but this method could be adapted:

http://support.microsoft.com/default...b;en-us;209857