I need assistance with the following. I have five Fields and must Calculate
Storage Days.

Date Received (Date/Time)
Date Stuffed (Date/Time)
Date Delivered (Date/Time)
Date Shipped (Date/Time)
Storage Days (Number, Calculated Field)

Here is what I want to accomplish:
If Date Received, Date Delivered and Date Shipped has value then Calculate
Storage Days (Which would be the difference between Received and Delivered
Dates)
Then If Date Received, Date Stuffed and Date Shipped has values then
calculate Storage Days (Which would be the difference Stuffed and Shipped
Dates)

Thanks

If Not IsNull([Date Received]) Then
If Not IsNull([Date Delivered]) And Not IsNull([Date Shipped]) Then
[Storage Days] = DateDiff("d", [Date Received], [Date Delivered]
Elseif Not IsNull([Date Stuffed] And Not IsNull([Date Shipped]) Then
[Storage Days] = DateDiff("d", [Date Stuffed], [Date Shipped]
End If
End If


"Levans digital" wrote:

> I need assistance with the following. I have five Fields and must Calculate
> Storage Days.
>
> Date Received (Date/Time)
> Date Stuffed (Date/Time)
> Date Delivered (Date/Time)
> Date Shipped (Date/Time)
> Storage Days (Number, Calculated Field)
>
> Here is what I want to accomplish:
> If Date Received, Date Delivered and Date Shipped has value then Calculate
> Storage Days (Which would be the difference between Received and Delivered
> Dates)
> Then If Date Received, Date Stuffed and Date Shipped has values then
> calculate Storage Days (Which would be the difference Stuffed and Shipped
> Dates)
>
> Thanks
>