Welcome to SPN

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

Sign Up Now!

strange criteria on filter for in Access XP

Discussion in 'Information Technology' started by Brian, Nov 9, 2005.

  1. Brian

    Brian
    Expand Collapse
    Guest

    Using the "Filtor For:" function on a text field in a table we get peculiar
    results without a logical answer.

    The field contains accounts head office number with numbers and text eg:

    006400
    064001
    0X7810
    FOR001

    if you filter for 006400 with quotes it returns correct results
    if you filter for "0X7810" it returns correct results
    if you filter for 0X7810 without quotes it returns no results
    if you filter for 064001 = no results

    It appears as if an account just has 1 zero in front it will not filter
    unless it is in quotes. All other combinations of numbers and charecters will
    return the same results regardless of quotes or not.

    Could not find any explanations in microsoft
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Strange Blue World: Alien Planet's True Color Revealed, a First Breaking News Jul 12, 2013
    Truth Stranger Than Fiction! Interfaith Dialogues May 26, 2012
    Dr. Strangestlove (Or How I learned To Stop Worrying And Love My Computer) Inspirational Stories May 22, 2011
    Estranged Women Seek Help from Ramoowalia! Hard Talk Mar 9, 2011
    Nature Stranger Than Paradise (The Adivassi and FRA) Breaking News Jun 16, 2010

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    When you filter on a string field you need to add quote before and after, if
    you dont add the quote the field will treat it as a number, and as such it
    will remove the 0 in the beginning of the parametes

    To filter on number, no need for quotes
    To filter on string add quotes before and after the parameter
    To filter on date field add # before and after thedate


    --
    The next line is only relevant to Microsoft''s web-based interface users.
    If I answered your question, please mark it as an answer. It''s useful to
    know that my answer was helpful
    HTH, good luck


    "Brian" wrote:

    > Using the "Filtor For:" function on a text field in a table we get peculiar
    > results without a logical answer.
    >
    > The field contains accounts head office number with numbers and text eg:
    >
    > 006400
    > 064001
    > 0X7810
    > FOR001
    >
    > if you filter for 006400 with quotes it returns correct results
    > if you filter for "0X7810" it returns correct results
    > if you filter for 0X7810 without quotes it returns no results
    > if you filter for 064001 = no results
    >
    > It appears as if an account just has 1 zero in front it will not filter
    > unless it is in quotes. All other combinations of numbers and charecters will
    > return the same results regardless of quotes or not.
    >
    > Could not find any explanations in microsoft
    >
    >
     

Share This Page