News, links, downloads, tips and tricks on Microsoft Access and related
Function Max(ByVal d1 As Date, ByVal d2 As Date) As Date Max = d1 If d2 > d1 Then Max = d2End FunctionFunction Min(ByVal d1 As Date, ByVal d2 As Date) As Date Min = d1 If d2 < d1 Then Min = d2End Function
Thanks for comments! I never used this function in query, so good to know!
Hi,Agree, that makes sense, but in most cases i use subqueries for such long-sql queries
Thanks for comments! I never used this function in query, so good to know!
ReplyDeleteHi,
ReplyDeleteAgree, that makes sense, but in most cases i use subqueries for such long-sql queries