Welcome to SPN

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

Sign Up Now!

How do I exclude records based on first two characters in cell

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

  1. Wheelz

    Wheelz
    Expand Collapse
    Guest

    I need to modify an ACCESS query to exclude records if the first two
    characters in a certain field begin with "AA". I should know how to
    specify this simple thing but I don't. I would appreciate your
    feedback.

    Ken
     
  2. Loading...

    Similar Threads Forum Date
    USA Protest to exclude Sonia Ghandhi from US Breaking News Mar 3, 2012
    Christianity SFU Study Shows Christmas Trees Can Make People Feel Excluded Interfaith Dialogues Dec 18, 2010
    Legal PTI Exclude land value from service tax: ICAI Breaking News Apr 12, 2010
    Sikh News Excluded Sikh pupil goes to court over religious bangle ban (Guardian Unlimited) Breaking News Jan 23, 2008
    Sikh News Excluded Sikh pupil goes to court over bangle ban (Guardian Unlimited) Breaking News Jan 23, 2008

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Not like "AA*"




    --
    Rick B



    "Wheelz" <Traderman04@yahoo.com> wrote in message
    news:1153251215.311640.66570@m73g2000cwd.googlegroups.com...
    >I need to modify an ACCESS query to exclude records if the first two
    > characters in a certain field begin with "AA". I should know how to
    > specify this simple thing but I don't. I would appreciate your
    > feedback.
    >
    > Ken
    >
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On 18 Jul 2006 12:33:35 -0700, Wheelz wrote:

    > I need to modify an ACCESS query to exclude records if the first two
    > characters in a certain field begin with "AA". I should know how to
    > specify this simple thing but I don't. I would appreciate your
    > feedback.
    >
    > Ken

    As criteria on that column, write:
    Not Like "AA*"
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  5. Wheelz

    Wheelz
    Expand Collapse
    Guest

    Thank you. You confirmed how I think it "should" work but it doesn't.


    fredg wrote:
    > On 18 Jul 2006 12:33:35 -0700, Wheelz wrote:
    >
    > > I need to modify an ACCESS query to exclude records if the first two
    > > characters in a certain field begin with "AA". I should know how to
    > > specify this simple thing but I don't. I would appreciate your
    > > feedback.
    > >
    > > Ken

    > As criteria on that column, write:
    > Not Like "AA*"
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
     
  6. Wheelz

    Wheelz
    Expand Collapse
    Guest

    Got it, thank you. I had two tables linked and had to run specify it on
    both.


    Rick B wrote:
    > Not like "AA*"
    >
    >
    >
    >
    > --
    > Rick B
    >
    >
    >
    > "Wheelz" <Traderman04@yahoo.com> wrote in message
    > news:1153251215.311640.66570@m73g2000cwd.googlegroups.com...
    > >I need to modify an ACCESS query to exclude records if the first two
    > > characters in a certain field begin with "AA". I should know how to
    > > specify this simple thing but I don't. I would appreciate your
    > > feedback.
    > >
    > > Ken
    > >
     
  7. Wheelz

    Wheelz
    Expand Collapse
    Guest

    Coming back to the well once more:

    How might I specify that I want to exclude ant record that has CDMA
    anywhere in a string in a spefic column?

    Wheelz wrote:
    > Got it, thank you. I had two tables linked and had to run specify it on
    > both.
    >
    >
    > Rick B wrote:
    > > Not like "AA*"
    > >
    > >
    > >
    > >
    > > --
    > > Rick B
    > >
    > >
    > >
    > > "Wheelz" <Traderman04@yahoo.com> wrote in message
    > > news:1153251215.311640.66570@m73g2000cwd.googlegroups.com...
    > > >I need to modify an ACCESS query to exclude records if the first two
    > > > characters in a certain field begin with "AA". I should know how to
    > > > specify this simple thing but I don't. I would appreciate your
    > > > feedback.
    > > >
    > > > Ken
    > > >
     
  8. Rick B

    Rick B
    Expand Collapse
    Guest

    not like "*CDMA*"


    --
    Rick B



    "Wheelz" <Traderman04@yahoo.com> wrote in message
    news:1153252889.111670.275780@b28g2000cwb.googlegroups.com...
    > Coming back to the well once more:
    >
    > How might I specify that I want to exclude ant record that has CDMA
    > anywhere in a string in a spefic column?
    >
    > Wheelz wrote:
    >> Got it, thank you. I had two tables linked and had to run specify it on
    >> both.
    >>
    >>
    >> Rick B wrote:
    >> > Not like "AA*"
    >> >
    >> >
    >> >
    >> >
    >> > --
    >> > Rick B
    >> >
    >> >
    >> >
    >> > "Wheelz" <Traderman04@yahoo.com> wrote in message
    >> > news:1153251215.311640.66570@m73g2000cwd.googlegroups.com...
    >> > >I need to modify an ACCESS query to exclude records if the first two
    >> > > characters in a certain field begin with "AA". I should know how to
    >> > > specify this simple thing but I don't. I would appreciate your
    >> > > feedback.
    >> > >
    >> > > Ken
    >> > >

    >
     

Share This Page