Welcome to SPN

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

Sign Up Now!

Show negative values

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

  1. Kirt84

    Kirt84
    Expand Collapse
    Guest

    Hello

    I need to design a query that only shows the values that are negative. Is
    this possible?

    --
    Thank you for your help
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    set the criteria as <0


    --
    Wayne
    Manchester, England.



    "Kirt84" wrote:

    > Hello
    >
    > I need to design a query that only shows the values that are negative. Is
    > this possible?
    >
    > --
    > Thank you for your help
     
  4. default105

    default105
    Expand Collapse
    Guest

    I have tried <0 with my one table and have gotten no results also with the
    field type as number but I was able to find the negitive values with this in
    the criteria

    Like "-*"

    HTH

    "Kirt84" wrote:

    > Hello
    >
    > I need to design a query that only shows the values that are negative. Is
    > this possible?
    >
    > --
    > Thank you for your help
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    default105 wrote:
    > I have tried <0 with my one table and have gotten no results also
    > with the field type as number but I was able to find the negitive
    > values with this in the criteria
    >
    > Like "-*"
    >
    > HTH
    >
    > "Kirt84" wrote:
    >
    >> Hello
    >>
    >> I need to design a query that only shows the values that are
    >> negative. Is this possible?
    >>
    >> --
    >> Thank you for your help


    Is it possible that the filed with the "numbers" in it is a text field?
    If it is a text field and for some reason you don't want to change it
    (likely you should) then how consistent are the negative "numbers" That is,
    is the first character always a "-" or a "(" and that character never
    appears in any other records in that table as the first character?

    --
    Joseph Meehan

    Dia duit
     

Share This Page