I have a query with the following fields to tell me the # of days an account has gone without being worked:
Assigned to date
# of Days: Sum(DateDiff("d",[Assigned
I need to see the accounts that are within the # of days column broken down by 30, 60, and 90 days.
If possible, I would also like to count or sum how many accounts are without work for 30, 60, and 90 days.
Can anybody help?