Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    7

    Help with quotations in DLookup

    Table1 has three fields. I’d like to use the following DLookup statement:

    DLookup(“[Field1]”,”Tablename”,”[Field2]=Left([Field3],4)&’55’”)

    Note that in the criteria, I want Field2 = the first 4 characters of Field 3 + the string value 55.


    I’m sure I’ve got the quotation marks wrong. Any help would be appreciated.

    Thanks,
    Kent

  2. #2
    Rod is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Location
    Metro Manila, Philippines
    Posts
    679
    Try:

    DLookup(“[Field1]”,”Tablename”,”[Field2] = ' " & Left([Field3],4) & Str(55) & "’”)

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

Similar Threads

  1. Dlookup help
    By justhininabouti in forum Programming
    Replies: 2
    Last Post: 11-26-2011, 10:53 PM
  2. Dlookup
    By cbrsix in forum Forms
    Replies: 2
    Last Post: 11-01-2011, 02:59 PM
  3. Quotations Database
    By Kari-z in forum Database Design
    Replies: 2
    Last Post: 01-26-2011, 09:03 AM
  4. dlookup help
    By gsantacruz in forum Programming
    Replies: 9
    Last Post: 10-11-2010, 11:46 AM
  5. DLookup()
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 09-15-2010, 07:20 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