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.

Tags:
  1. Ben.j.howard@gmail.com

    Ben.j.howard@gmail.com
    Expand Collapse
    Guest

    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

    Regards,

    Ben
     
  2. Loading...


  3. Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse
    Guest

    Ben,

    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!

    HTH,
    Nikos
     

Share This Page