I have 4 queries that pulls 4 different date fields:
Query 1 - Date1
Query 2 - Date2
Query 3 - Date3
Query 4 - Date4
All have a common field of FILENUM
I am trying to incorporate the most recent date from all 4 of these queries into a final query that will place the most recent date from the 4 queries into 1 field on the output MAX_FieldDate.
If Date1 = 01/01/2010 and Date2 = 01/01/2011 and Date3 = 01/01/2012 and Date4 = 01/01/2013 I want my final query to find Date4 and return it in a field in my final query. I understand I may need to make additional tables or possibly a module but not sure and do not want to bang my head against the wall for too long on this.
Thanks in advance for the assistance...