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...

    Similar Threads Forum Date
    Interfaith So Help Me O’ God, Yahweh, Allah, Vaheguru, Et. Al…… Interfaith Dialogues Wednesday at 2:03 AM
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Khalsa Aid Sikh Charity Praised For Helping Stranded UK Travellers Sikh Organisations Jul 26, 2016
    Sikh News Sikh Charity Praised For Helping Stranded UK Travellers - NDTV Breaking News Jul 26, 2016
    HELP ME! Sikh Sikhi Sikhism Mar 19, 2016

  3. 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!


Share This Page