Writing Expressions in Access

[Guest]

This is a simple expression, I just am having issues today. I am trying to
write an expression that show the difference between 2 fields and if the
second field is 0 then no total would display.

 

[chris.nebinger]

iif(nz(Field2) = 0, null, abs(field1 - field2))



Chris Nebinger

 

[chris.nebinger]

iif(nz(Field2) = 0, null, abs(field1 - field2))



Chris Nebinger

 

[Guest]

OK so this is what I have
= iif(Reviewed Value) = 0, null, ([Complete Date] - [Reviewed Value)

I get a Syntax Error

 

[Guest]

iif Reviewed value is "0" then Cut Value is "0" otherwise Original Cost -
REviewed Value in Cut Value

That is what I trying to write. I can do the subraction expression fine,
but I am having a block when it comes the the rest.

 

[John Spencer]

Watch those parentheses and square brackets. They must match up. I think
what you need is:

IIF([Reviewed Value] = 0, null, [Complete Date] - [Reviewed Value])

OK so this is what I have
= iif(Reviewed Value) = 0, null, ([Complete Date] - [Reviewed Value)

I get a Syntax Error

iif(nz(Field2) = 0, null, abs(field1 - field2))



Chris Nebinger

 

[Guest]

Huh, I knew it was something simple. I was leaving the "null" out!

Thanks sir.

Watch those parentheses and square brackets. They must match up. I think
what you need is:

IIF([Reviewed Value] = 0, null, [Complete Date] - [Reviewed Value])

OK so this is what I have
= iif(Reviewed Value) = 0, null, ([Complete Date] - [Reviewed Value)

I get a Syntax Error

iif(nz(Field2) = 0, null, abs(field1 - field2))



Chris Nebinger

Casey P wrote:
This is a simple expression, I just am having issues today. I am
trying to
write an expression that show the difference between 2 fields and if
the
second field is 0 then no total would display.

 

[John Vinson]

OK so this is what I have
= iif(Reviewed Value) = 0, null, ([Complete Date] - [Reviewed Value)

I get a Syntax Error

Count parentheses and square brackets. You have no closing square
bracket after Reviewed Value, and you have two left parentheses and
only one right parenthesis. They've got to balance!

Try

= iif(Reviewed Value) = 0, null, ([Complete Date] - [Reviewed Value]))


John W. Vinson[MVP]