How do I select the first instance of an occurance within a Range?

[FindingAccess]

I need some help quickly, my boss is expecting a report within 5 days or my
goose is cooked.
Any help is appreciated.
Thanx,
Furstrated

 

[Allen Browne]

If you just want to retrieve a single value, DLookup() might be enough.
Basics here:
http://members.iinet.net.au/~allenbrowne/casu-07.html

Unfortunately, DLookup() does not let you define *which* value it will
return. For a replacement that lets you specify how the records should be
sorted to define which is "first", see this extended replacement for
DLookup():
http://members.iinet.net.au/~allenbrowne/ser-42.html

If you need this in a query, you could use a subquery. This article explains
4 possible approaches:
http://www.mvps.org/access/queries/qry0020.htm