Joined: 19 Sep 2007
Location: United States
Online Status: Offline
Posts: 2
Topic: isnull help needed Posted: 19 Sep 2007 at 4:53pm
I have 3 fields. In order of priority they are RetirementDate, BuyoutDate, and LeaseEndDate. For every record the possibility exists that RetirementDate and BuyoutDate are null. I have been unable to figure out the proper syntax for an if then formula that says
if RetirementDate & BuyoutDate are null then LeaseEndDate else
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
