no zero (2k)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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)

0;0;""

if you have whole numbers, or

0.00;0.00;""

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.

Reply | Quote

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

Reply | Quote

Add a condition in your criteria line under the Net expression. Here is the criteria: 0

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

Use this expression for net:

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

and set the criteria to 0.

Reply | Quote

Thank u Hans
Ashraf

Reply | Quote

Thank u Hans
Ashraf

Reply | Quote

Use this expression for net:

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

and set the criteria to 0.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

Add a condition in your criteria line under the Net expression. Here is the criteria: 0

Reply | Quote

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

Reply | Quote

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)

0;0;""

if you have whole numbers, or

0.00;0.00;""

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.

Reply | Quote

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

Reply | Quote