Full Version: Conditional Calculated fields
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
Thr33of4
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?
niesz
=IIf(Date1 Is Not Null and Date2 Is Not Null,DateDiff("d",Date1,Date2),"")
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.