Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    After reading all the post I still can't get DLookup to work

    I want to create a query using DLookup.
    I've tried so many combinations in writing a query but I keep getting errors
    due to synax. I'm ready to quit but I know it's something simple.


    Could someone help me?

    I'm trying to create a make table query using DLookup.
    I want to extract the UNIT_PRICE and REPAIR_PRICE from TABLE2 were the DATE_ORD in TABLE1
    falls between the DATE_BEGIN and DATE_END of TABLE2.


  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Don't use DLookup for this. In general, its a bad idea to embed any kind of domain function within a query...it can lead to very poor performance.

    Instead, have your Make Table query join Table1 to Table2 on the Item number and use a where clause for the date in Table1 to be between the begin and end dates in Table2.

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

Similar Threads

  1. Reading outlook tasks from Access
    By Bill_dom in forum Import/Export Data
    Replies: 0
    Last Post: 08-07-2008, 06:02 PM
  2. Can't get TransferSpreadsheet to work
    By Valeda in forum Import/Export Data
    Replies: 0
    Last Post: 07-19-2007, 08:04 AM
  3. Nested IIf query will not work
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 06-20-2006, 02:03 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
  •  
Other Forums: Microsoft Office Forums