Actually they are not identical. I just posted only the information that I needed since my query was too large to add to the thread. I just shortened up the query to ask the question. Basically I am trying to pull the latest evaluation by using the max() function within a date field instead of last year's employee evaluation. I do know there are values in there if I query without the max() function. With it, the field shows only null values. I am wondering if I would have to adjust the format in my query to show how the dates should show up, but I'm not sure.