Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I have the following code in a form that works OK

    I

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    It's not clear to me what you want to accomplish, but does this do what you want?
    <code>
    strIDSQL = "SELECT " & _
    cboLookupSequence & " & (' - ' & " + SuiteNo + ")" & ", " & _
    ID & ", " & _
    AssessorPermit & ", " & _
    AssessorOutcome & ", " & _
    AssessorInspector</code>

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I tried your suggestion and it returns the following:

    Madison Ave 42

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Can you post a small zipped sample database?

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I will work on that, in the meantime I put the following in the underlying query

    [strAddrNameNoAss] & (" - "+[ SuiteNo])

    Thanks for your help

    John

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Congratulations on becoming a SilverLounger! (1600 posts) <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help With Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I shoulda, coulda, woulda been there sooner, my posts are down, which is a direct reflection of getting proficent in access with help I have received from you and others on the lounge.

    Thanks, John

Posting Permissions

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