Could someone please show me an example of how the first function in a quesry works? Thanks, Regi
R Regi May 9, 2006 #1 Could someone please show me an example of how the first function in a quesry works? Thanks, Regi
J Jeff Boyce May 9, 2006 #2 I suspect that what you want (first in a sorted list) and what Access uses First() for are not the same. If you want the first (earliest) in a date field, use Min(). For the most recent date, use Max(). -- Regards Jeff Boyce Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/
I suspect that what you want (first in a sorted list) and what Access uses First() for are not the same. If you want the first (earliest) in a date field, use Min(). For the most recent date, use Max(). -- Regards Jeff Boyce Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/
