Results 1 to 3 of 3

Thread: expression..

  1. #1
    Join Date
    Jul 2009
    Posts
    9

    Unanswered: expression..

    hi every one...

    Does anyone knew whats wrong in this expression in..

    Application Source: DLookUp("[Sales Type Description2]","[RegionalApplicationSource]","[Sales Type Description]=" & nz([Sales Type Description],0))

    i used this in select query.. Sales Type Description hold string like "Agency Prior" or " Walkin SM", etc. while Sales Type Description2 contains "Agency" or "FinalDevelopment"..

    when i run the query i get the error:

    "Syntaz error: Missing operator in query expression '[Sales Type Description]=Agency Prior'


    but here in my other select query, this below expression works.. they are almost the same except for the data fields..

    Application Source: DLookUp("[Group]","[LEC_Consumer]","[SO Number]=" & nz([So Number],0))

    Group contains stings like "Mail To Mail" or "Metro Gwapo"
    SO Number contains number..

    san some one help me on this..

    thanks!
    Last edited by arjoseph; 07-27-09 at 06:54.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if the column in the table is string the parameter must be enclosed in quote marks, either " or '

    "[Sales Type Description]='" & [Sales Type Description] & "'",0))
    or
    "[Sales Type Description]=" & chr(34) & [Sales Type Description] & chr(34),0))
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2009
    Posts
    9
    thanks a lot! now i can move on... weeeeeeeeewwww!

Posting Permissions

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