Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2009
    Posts
    4

    Question Unanswered: Is the ELookUp or DLookUp function can be retrieve all the rows

    hi all

    Is the ELookUp or DLookUp function can be retrieve all the rows Equals the Criteria ?
    I think it is Possible by Modified the Criteria ,, but i did not know how so who is know ?
    plz add example

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    DLookup and ELookup only return one value.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Paul

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    OMG that's sad.

    Maybe I should start a topic "How do I make $1M by using Access?" and await the answer... and if the answer isn't the one I want then I will just spam the next forum
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Oct 2009
    Posts
    4
    Quote Originally Posted by StarTrekker
    OMG that's sad.

    Maybe I should start a topic "How do I make $1M by using Access?" and await the answer... and if the answer isn't the one I want then I will just spam the next forum
    i thenk u rae funny ,,, are u mister bean

    i thenk i did not ask good question ,, so let me try again

    Is there a function that can retrieve all values which are Compatible with Criteria?
    thanx
    Last edited by m00j; 10-06-09 at 06:03.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    run a query which returns a recordset
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Oct 2009
    Posts
    4
    i am Ready do it but with poor Solution here
    http://rapidshare.com/files/289479616/Example1.rar.html

    so any one give me Another Idea
    Last edited by m00j; 10-06-09 at 14:33.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    have a look at google:-
    Google
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Oct 2009
    Posts
    4

    Cool

    Quote Originally Posted by healdem
    have a look at google:-
    Google
    be cool man

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Is there a function that can retrieve all values which are Compatible with Criteria?
    Yes. It's called a QUERY.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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