Results 1 to 11 of 11

Thread: no zero (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    no zero (2k)

    i have a queri depond on a tabl contain the fealds ( name-value1-sdad1) and finelly net ( sum of valu1-sumsdad1)some times net = 0 i want all net = 0 not apear in the queri i try to put >0 but faild
    Ashraf

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: no zero (2k)

    Do you want to exclude records for which net = 0 from the query, or do you want to hide zero values from being displayed?

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: no zero (2k)

    i want to hide zero values from being displayed .
    Thanks
    Ashraf

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: no zero (2k)

    You can do that by setting the Format property of the net column. A custom Format can consist of 1 to 4 sections, separated by semicolons. The first section is for positive numbers, the second for negative numbers, the third for zero values and the fourth for Null values. To suppress zero values, you can use (for example)

    <code>0;0;""</code>

    if you have whole numbers, or

    <code>0.00;0.00;""</code>

    if you want to display numbers with 2 decimal places. You will probably also have to set this format for text boxes on a form or report bound to the net field.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: no zero (2k)

    i think i can not explan good .
    i want only the records that contain value apeers in the qurey and the 0 value not apeard .
    Ashraf

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: no zero (2k)

    Add a condition in your criteria line under the Net expression. Here is the criteria: <code><> 0</code>
    Charlotte

  7. #7
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: no zero (2k)

    i do it but the criteria ask me to add sum of the value1 and sum of the sdad1 .

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: no zero (2k)

    Could you attach a stripped down copy of your database? It's hard to understand what you are talking about.

  9. #9
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: no zero (2k)

    i want in the q_sum only feald name (4-5) and hide a 0 value .

  10. #10
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: no zero (2k)

    Thank u Hans
    Ashraf

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: no zero (2k)

    Use this expression for net:

    net: Sum([Value1])-Sum([sdad1])

    and set the criteria to <>0.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •