L
lmossolle
I have a date field "daterecieved" i would like to query for items over 30
days old where a completed field is null. Please assist. I am trying to get
the number of items over 30 days old if the completed field is Null. The
daterecieved it the item I want to use to capture the 30 day.
I tried this and was unsuccessfull.
Sum(IIf(daterecieved < Date() - 30 AND completed Is Null)) AS daysoverdue
Thanks!!!
days old where a completed field is null. Please assist. I am trying to get
the number of items over 30 days old if the completed field is Null. The
daterecieved it the item I want to use to capture the 30 day.
I tried this and was unsuccessfull.
Sum(IIf(daterecieved < Date() - 30 AND completed Is Null)) AS daysoverdue
Thanks!!!