answersLogoWhite

0

You would need to exclude the unwanted values in the where clause of the query, for example;

select * from InvoiceLines where InvoiceValue <> 0

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

When is a racional expression undefined?

a rational expression is undefined when the denominator is 0 because we cannot dvide by 0.


What is an algebraic expression that is not equal called?

An algebraic expression that is not equal (Such as 3=0) is called an inequality, and can be expressed as 3&ne;0.


Are there examples of expressions in Microsoft Access?

They are like formulas that can be built into Access, often on a form or a query in order to calculate something. In general in databases, anything that can be calculated from other data should not be in a field. For example, if you have the date of birth stored in a field then you should never have the age stored. The age can always be calculated from the date of birth and be accurate at all times. An age changes every year, but the date of birth never does. You would do that calculation by using an expression. If you have the amount of hours worked and the rate of pay, then you can calculate the actual wage at any time, so that does not need to be stored either, and it can be calculated through an expression. So expressions are very useful for doing things in Access.


What is the expression for the metric tensor in spherical coordinates?

The expression for the metric tensor in spherical coordinates is given by: gij beginpmatrix 1 0 0 0 r2 0 0 0 r2 sin2(theta) endpmatrix


What is principal of Duality?

According to principle of duality"Dual of one expression is obtained by replacing AND (.)with OR(+) and OR with AND together with replacement of 1 with 0 and 0 with 1. For example: consider the expression A+B=0. The dual of this expression is obtained by replacind + with . and 0 by 1. ie A.B=1 is dual of A+B=0


What is if statement in c language?

first i would like to tell about if . if is keyword in c language . if is check the condition(expression) .if the expression is non zero value the condition is true .it will the go through the fallowing operations .other wise the condition is failed. if(expression) { } if the expression is &gt;0 ,&lt;0 these statements are execute inside the if statement. if the expression is =0 condition is failed.


What value of x makes the expression x undefined?

+1/0 or -1/0 or 0/0


Which expression do not have a solution of 0?

Most expressions.


What is the value of the expression when a 0 and b 3?

It would depend on the expression that you have in mind but chose not to share!


In evaluating a logical expression of the boolean expression 1 and and boolean expression 2 both the boolean expression are not always evaluted?

That is correct. Any processor worth it's salt will, when evaluating an expression like "1 and 0 and 1 and 1 and 0" will get as far as the first zero and "realize" that full expression will result in false regardless of the rest.


Which expression shows the result of applying the Commutative Property of Multiplication to the expression 0 9 7 2 6?

0*9*7*2*6 = 9*6*7*2*0


What is the -6 in the expression -6X?

0