UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Conditional Calculated fields    
 
   
Thr33of4
post Sep 11 2005, 05:47 PM
Post #1

UtterAccess Enthusiast
Posts: 92
I have a form that has a calculated field based on the difference between two dates. The calculation obviously errors if both date fields are not filled in. This happens upon moving to a new record where neither dates are filled in. How do I make the calculation conditional to both dates being filled in?
Go to the top of the page
 
+
niesz
post Sep 11 2005, 06:27 PM
Post #2

Utter A-fishin'-ado
Posts: 17,723
From: Cincinnati, Ohio, USA . . . ><((((°>
=IIf(Date1 Is Not Null and Date2 Is Not Null,DateDiff("d",Date1,Date2),"")
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 01:48 AM