Expression in Query

  • Thread starter Thread starter Ty
  • Start date Start date
SomeName: IIf ( [TableName]![Field2] = 0 , [TableName]![Field1] /
[TableName]![Field2] , [TableName]![Field1] )
 
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...
 
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...
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reusable statements in queries 2
Query Parameter using multiple options 0
Finding null 4
Count field 4
validation rule (for a record in a table) with dlookup 7
Report showing ZLS as null 2
Calculate Null Field 2
How to query 1

Back
Top