[AccessD] Missing Dates

Hello All,

I recently read an article about 'missing dates'.  I know we discussed this in the past...but our archives don't search very well.  The results are limited by some random dates...anyway....


Any thoughts on the approach I used...speed,accuracy...all that good stuff.  I needed to find the earliest date not listed in the closed_date field.  All of the other approaches seemed to be very complicated, using case statements, arrays, temp tables...mine seems too simple.  Any thoughts?

*****************SQL START*************************
SELECT Min([tblCase]![closed_date]+1) AS MD
FROM tblCase LEFT JOIN tblCase AS tblCase_1 ON ([tblCase].[closed_date]+1) = tblCase_1.closed_date
WHERE (((tblCase_1.closed_date) Is Null));
*****************SQL END*************************


Thanks,

Mark A. Matte
_________________________________________________________________
Helping your favorite cause is as easy as instant messaging. You IM, we give.
http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join