Access Query Help!!!

[merc007]

I have 3 fields in my table. "ListDate", "SoldDate", "CurrentDate". I am trying to create an expression with the following: OnMarket: IIf([SoldDate]="","",[CurrentDate]-[ListDate])

When I run this query it gives me #Error only on the ones that have dates in the "SoldDate" field. How do I rectify this problem? Any help would be greatly appreciated. Thank you.

 

[PHV]

Perhaps this ?
OnMarket: IIf(IsNull([SoldDate]),Null,[CurrentDate]-[ListDate])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

IIf ( IsNull([SoldDate]), '', Format([CurrentDate]-[ListDate],"0") )

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[merc007]

You Guys Rock