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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete range names within a selection 13
counting the occurrence of specific text within a date range 4
Can Vba workout if a selection is part of a group? 0
count number of instances a number occurs 5
how do i write an if then or formula where the value being "tested"is a RANGE of numbers?? 7
Having Excel calculate the number of times a range of values occur 2
Auto increment within a defined range 0
Need Help with Totaling 2

Back
Top