Results 1 to 2 of 2

Thread: Dlookup

  1. #1
    Join Date
    May 2003
    Posts
    144

    Unanswered: Dlookup

    Can we have "Order By" in the DLookup statement?
    It's giving me an error.

    Thanks

    SHK

  2. #2
    Join Date
    Mar 2004
    Posts
    2
    By wanting to include an order by clause you're implying that your criteria could be returning more than one row. DLookup is intended for a one row return set. You could try DFirst or possibly DMax depending on how your data is sorted by default.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •