Expression in Query

W

Wayne-I-M

SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1] /
[TableName]![Field2] , [TableName]![Field1] )
 
K

KARL DEWEY

Maybe like this ---
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1],
[TableName]![Field1] / [TableName]![Field2] )

--
KARL DEWEY
Build a little - Test a little


Wayne-I-M said:
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1] /
[TableName]![Field2] , [TableName]![Field1] )


--
Wayne
Manchester, England.



Ty said:
How to create Expr in Query Field1/Field2 if Field 2 is zero return Field1?
Click to expand...
Click to expand...
 
W

Wayne-I-M

ooops - yes you're right.


--
Wayne
Manchester, England.



KARL DEWEY said:
Maybe like this ---
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1],
[TableName]![Field1] / [TableName]![Field2] )

--
KARL DEWEY
Build a little - Test a little


Wayne-I-M said:
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1] /
[TableName]![Field2] , [TableName]![Field1] )


--
Wayne
Manchester, England.



Ty said:
How to create Expr in Query Field1/Field2 if Field 2 is zero return Field1?
Click to expand...
Click to expand...
Click to expand...
 
T

Ty

Thank you very much!

Wayne-I-M said:
ooops - yes you're right.


--
Wayne
Manchester, England.



KARL DEWEY said:
Maybe like this ---
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1],
[TableName]![Field1] / [TableName]![Field2] )

--
KARL DEWEY
Build a little - Test a little


Wayne-I-M said:
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1] /
[TableName]![Field2] , [TableName]![Field1] )


--
Wayne
Manchester, England.



:

How to create Expr in Query Field1/Field2 if Field 2 is zero return Field1?
Click to expand...
Click to expand...
Click to expand...
 
Top