Search results

thanks again

the current formula in excel is =IF([DATE IN]>=[START DATE];[DATE OUT]-[DATE IN];[DATE OUT]-[START DATE]) how would i use this in access

you are the best it works perfectly thanks i was dreading trying to put nested iif commands together

i am busy with creating a access storage database and need to calculate the number of days a vehicle is in storage, i have a [date in] field and a [date out] field. i need to calculate if [date out] is empty to use today otherwise [date out] - [date in]