IIf problem

[Pete Provencher]

Access 2000



I have three sales dates for property, (NBHD_Sales_Price_1,
NBHD_Sales_Price_2, NBHD_Sales_Price_3). I want to create a new field, which
I will update using a query. I want the query to look at the three dates and
to update the new field with the latest date. I attempted to write an IIF
statement to perform this operation but it errors out with :



The expression you entered has a function containing the wrong number of
arguments



My formula is;




IIF([NBHD_Sales_Price_3]>0),[NBHD_Sales_Price_3],(IIF([NBHD_Sales_Price_2]>0
),[NBHD_Sales_Price_2],[NBHD_Sales_Price_1])



Any help will be appreciated.





Pete Provencher

 

[John Viescas]

Your parens are in the wrong place:

IIF([NBHD_Sales_Price_3]>0,[NBHD_Sales_Price_3],IIF([NBHD_Sales_Price_2]>0,[
NBHD_Sales_Price_2],[NBHD_Sales_Price_1]))

But note that you're comparing you values to zero, not to each other.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Pete Provencher]

Worked great. thanks

Pete

Your parens are in the wrong place:

IIF([NBHD_Sales_Price_3]>0,[NBHD_Sales_Price_3],IIF([NBHD_Sales_Price_2]>0,[
NBHD_Sales_Price_2],[NBHD_Sales_Price_1]))

But note that you're comparing you values to zero, not to each other.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

Access 2000



I have three sales dates for property, (NBHD_Sales_Price_1,
NBHD_Sales_Price_2, NBHD_Sales_Price_3). I want to create a new field, which
I will update using a query. I want the query to look at the three dates and
to update the new field with the latest date. I attempted to write an IIF
statement to perform this operation but it errors out with :



The expression you entered has a function containing the wrong number of
arguments



My formula is;

IIF([NBHD_Sales_Price_3]>0),[NBHD_Sales_Price_3],(IIF([NBHD_Sales_Price_2]>0

),[NBHD_Sales_Price_2],[NBHD_Sales_Price_1])



Any help will be appreciated.





Pete Provencher