I was just writing a procedure where I needed to grab the max date from a table and store it in a variable for later use. The table is a fairly large one, with a continuous string of dates from many years ago right up to yesterday (10/5). I first tried to use a DMAX() function, but for some reason the result stopped several years back, around the end of 2015. I gave up on that and used a recordset approach with basically the same select criteria, which gave me one record with the correct maximum date.
So my problem is solved, albeit with rather more code than I'd have needed with DMAX. but I'm left scratching my head about why DMAX gave me a bogus answer. Is there some limitation on the number of records it can crunch? Haven't seen anything in HELP about that. The table in question has records going all the way back to 1980, almost 14000, so I could imagine running up against some kind of ceiling.