With all due respect to the suggestions posted, but No no no and once again no....
Dmax and Dlookup should be avoided like the plague and inline subselects are as bad as those two.
Assuming you take a measurement EVERY DAY, a simple self join can do the trick.
Building on what @MajP posted, it...