Find the earliest date from multiple dates in a row

[grampygrumpy]

My Access database has 9 columns that contain a date. I need to select the earliest date in each row. Note: All columns in some rows may not have a date. In those cases, I will leave the results field blank. Thank you,

 

[petertenthije]

Then create a query that deletes all contents from TBL_Temporary_Table_1. That's pretty straight forward. I have called this formula ADD_Temporary_table:

I can't edit the previous message anymore, but the name of the delete query should be DEL_Temporary_Table. \
You might have already figured that from the names I added to the macro description.

 

[grampygrumpy]

Peter, Thanks for providing your suggestion. I believe that the suggestion xenou made may be the more appropriate solution for my problem but I will try your suggestion. I appreciate your providing this level of explanation. If anything it will get me to learn how to use Visual Basic.