Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Concatenation and quotation character

Discussion in 'Information Technology' started by Gina K, Jul 28, 2006.

  1. Gina K

    Gina K
    Expand Collapse
    Guest

    Hi All,

    Is there a way to add the " character to a concatenation, i.e. I want to
    return 15" (15 inches). I get an error when I try: [Inches] & """

    Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Are these quotations real? Questions and Answers Feb 13, 2012

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Gina,

    you need 4 double quote marks, not 3

    this is because a double quote mark inside a quoted string
    using double quote marks will be mis-interpreted.... to
    actually make Access understand that is what you want, you
    need to use 2 of them


    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    Gina K wrote:
    > Hi All,
    >
    > Is there a way to add the " character to a concatenation, i.e. I want to
    > return 15" (15 inches). I get an error when I try: [Inches] & """
    >
    > Thanks.
     

Share This Page