First Function in a query question

[Guest]

Could someone please show me an example of how the first function in a quesry
works?

Thanks, Regi

 

[Jeff Boyce]

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/