• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

Which value does DLookup() return when multiple records satisfy the criteria?

In the MS Help for the DLookUp function, it says:
'If more than one field meets 'criteria', the DLookup function returns the first occurrence."
If the domain is a select query, does 'first' means first in query sort order? In other words, if I open the select query 'MyQuery' (sorted by Income ASC), and the first Income value greater than $1000 that I see that is $1008, then DLookup("Income","MyQuery","Income>1000") is sure to return 1008?
0
Milewskp
Asked:
Milewskp
  • 4
  • 2
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
it should.
0
 
MilewskpAuthor Commented:
Is there any documentation available that supports this?
0
 
Rey Obrero (Capricorn1)Commented:
the Help file is your documentation
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Rey Obrero (Capricorn1)Commented:
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<the domain is a select query, does 'first' means first in query sort order? >>

  Yes, I tested it.
JimD.
0
 
MilewskpAuthor Commented:
Thanks!
0
 
Rey Obrero (Capricorn1)Commented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now