IIf problem

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

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
 
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)
 
Worked great. thanks

Pete
John Viescas said:
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 said:
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;
Click to expand...
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
Click to expand...
Click to expand...
 
Back
Top