Results 1 to 4 of 4

Is the ELookUp or DLookUp function can be retrieve all the value

  1. #1
    m00j is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    2

    Question Is the ELookUp or DLookUp function can be retrieve all the value

    Is the ELookUp or DLookUp function can be retrieve all the value which are Compatible with Criteria?
    I think it is Possible by Modified the Criteria ,, but i did not know how so who is know ?
    or
    Is there a function that can retrieve all values which are Compatible with Criteria?
    plz add example


    Last edited by m00j; 10-06-2009 at 03:27 AM.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,896
    All of the Domain functions are designed to return one value. Queries are used to return recordsets for a certain criteria.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    m00j is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    2
    i am Ready do it but with poor Solution here in Attach Files make look


    so any one give me Another Idea

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,896
    Try playing with the query wizaed.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Dlookup
    By janjan_376 in forum Access
    Replies: 20
    Last Post: 07-07-2009, 07:40 AM
  2. Replies: 0
    Last Post: 06-03-2009, 10:25 PM
  3. Replies: 1
    Last Post: 06-20-2007, 07:26 PM
  4. I have Problem in processing Dlookup Function
    By Katada in forum Programming
    Replies: 2
    Last Post: 04-23-2006, 12:07 AM
  5. Need Help for Dlookup function
    By wasim_sono in forum Programming
    Replies: 5
    Last Post: 01-04-2006, 08:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums