Welcome to SPN

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

Sign Up Now!

Using query Wizard

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

  1. Wheelz

    Wheelz
    Expand Collapse
    Guest

    I need to exclude records if they inlude one or more text strings. I
    can exclude the first one fine by simply "Not like "*CDMA*" but I also
    want to exclude records where they equal "CDMA" in the same column.

    Would it be the following?

    "Not Like "*CDMA*" or Not Like "*TDMA*" on the same row that I would
    enter?
     
  2. Loading...


  3. gumby

    gumby
    Expand Collapse
    Guest

    Try this

    Not Like "*CDMA*" And Not Like "*TDMA*"

    David


    Wheelz wrote:
    > I need to exclude records if they inlude one or more text strings. I
    > can exclude the first one fine by simply "Not like "*CDMA*" but I also
    > want to exclude records where they equal "CDMA" in the same column.
    >
    > Would it be the following?
    >
    > "Not Like "*CDMA*" or Not Like "*TDMA*" on the same row that I would
    > enter?
     
  4. Wheelz

    Wheelz
    Expand Collapse
    Guest

    Peferct...thank you..!!


    gumby wrote:
    > Try this
    >
    > Not Like "*CDMA*" And Not Like "*TDMA*"
    >
    > David
    >
    >
    > Wheelz wrote:
    > > I need to exclude records if they inlude one or more text strings. I
    > > can exclude the first one fine by simply "Not like "*CDMA*" but I also
    > > want to exclude records where they equal "CDMA" in the same column.
    > >
    > > Would it be the following?
    > >
    > > "Not Like "*CDMA*" or Not Like "*TDMA*" on the same row that I would
    > > enter?
     

Share This Page