----------------------------I must be having (yet another) off-day: I can't find a way to update one table with the min value from another table:
UPDATE FilesData SET FirstFileDate = MIN(File_Date) + FROM FilesData T1, Files T2 + WHERE T1.IdNum = T2.File_Code Thanks in advance for any guidance, Regards, Alastair ---------------------------- Alastair Burr St. Albans, UK. [email protected] -----------------------------
