Welcome to SPN

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

Sign Up Now!

Help With SQL Like

Discussion in 'Information Technology' started by Ben.j.howard@gmail.com, Jul 28, 2006.

  1. Ben.j.howard@gmail.com

    Expand Collapse

    Hi there,

    I'm very new to this and just need to write something quickly. I am
    producing a query which garbs a value from a form.

    I have the field of TCT passed from the form e.g. [Forms]![PS
    Distribution Report Criterion]![Courier]

    However with the result i would like to find all records that contain
    the word TCT.

    I've tried using LIKE "*[Forms]![PS Distribution Report
    Criterion]![Courier]*" however that does not work.

    Is there a way of making this work


  2. Loading...

  3. OP
    Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse


    It's the syntax... as is, "*[Forms]![PS Distribution Report
    Criterion]![Courier]*" is recognized as a text string (because it is
    enclosed in quotes, rather than as an object reference, which is what
    you need. Try this:

    LIKE "* " & [Forms]![PS Distribution Report
    Criterion]![Courier] & "*"

    (all in one line, in case it gets wrapped in your newsreader).

    PS: not a good idea to post your e-mail undisguised, you're making
    spammers' day!

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page