I have a query that I use to pull the dates from a table and then I set the Unique Value field to Yes to remove all the duplicate dates. So now I have a list of unique dates.

What I would like to do is filter this list so that only the most current date is displayed. The most current date is variable so I can not use = “01/01/2004” I need to use something like = [most current date]

=DMax("MyField", "MyTable")

Found a post by BLeslie88 where he suggested using:

Select Top 1…

And I was just coming back here to post that I found the answer.

Thanks Mile.